Generate MD5 hash string with T-SQL
sql-server, sql-server-2008, t-sql
Solution
CONVERT(VARCHAR(32), HashBytes('MD5', 'email@dot.com'), 2)
Problem
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@dot.com')), 3, 32) ``` So it could be used inside a view with SCHEMABINDING