HashBytes Function - Change varbinary output

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

magarity kerns SSCrazy Points: 2763 More actions · Answer 1

Your original message is getting old; did you find that the answer is to use the master.dbo.fn_varbintohexstr function?

Codezilla-292868 SSChasing Mays Points: 644 More actions · Answer 2

Did you find an answer to this question? I am facing the same issue. I do not want to convert it to varbinary. I would like to use varchar instead.

Thanks in advance.

Ken McKelvey SSCoach Points: 18867 More actions · Answer 3

Try casting to bigint and using the fnNumber2AnyBase function at the following link.

Jacob Luebbers SSCarpal Tunnel Points: 4834 More actions · Answer 4

Also check out http://support.microsoft.com/kb/104829 for the (slightly old but still valid) Microsoft function.

Lee Fisher SSC Veteran Points: 290 More actions · Answer 5

There is an undocumented function that will help

DECLARE @HashThis varchar(255);

SELECT @HashThis = 'Hello world!'

SELECT HashBytes('MD5', @HashThis)

SELECT SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', @HashThis)), 3, 32)

mimran18 SSC-Addicted Points: 451 More actions · Answer 6

You can convert hashbytes to varchar through XQuery as well.

MI
http://raresql.com