SQL Server : Generate MD5 hash string with T-SQL

Here is the code to generate MD5 hash of an email address:

select convert(varchar(32), hashbytes('MD5', 'Test@email.com'), 2)

It will return a 128 bit hash
F71EC72738666D7E6177DFF360BBFA0F

Advertisements