Convert HashBytes to VarChar
I intend to get the MD5 Hash of a string value in SQL Server 2005. I do this with the adhering to command:
SELECT HashBytes('MD5', 'HelloWorld')
However, this returns a VarBinary as opposed to a VarChar value. If I try to transform
0x68E109F0F40CA72A15E05CC22786F8E6 right into a VarChar I get
há ðô§*à\Â'†øæ as opposed to
Exists any kind of SQL - based remedy?