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 68E109F0F40CA72A15E05CC22786F8E6.

Exists any kind of SQL - based remedy?


2019-05-09 11:12:08
Source Share
Answers: 1

I have actually located the remedy else where:

SELECT SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', 'HelloWorld')), 3, 32)
2019-05-12 10:43:31