Generate MD5 hash string with T-SQL

Question

Is there a way to generate MD5 Hash string of type varchar(32) without using fn_varbintohexstr

SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', '[email protected]')), 3, 32)

So it could be used inside a view with SCHEMABINDING

Answer 1

CONVERT(VARCHAR(32), HashBytes('MD5', '[email protected]'), 2)