Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 MD5 encryption

Author  Topic 

ekaiser
Starting Member

3 Posts

Posted - 2013-02-13 : 11:23:32
I have a table that contains thousands of rows of emails. I want to create another field on my table that has a MD5 encrypted version of the email field. so end result would be 2 fields ,
1 = original email and
2 = new field containing MD5 hash version of first field.

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2013-02-13 : 11:50:53
See if "HASHBYTES" is what you are looking for.

djj
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2013-02-13 : 16:35:08
Keep in mind HASHBYTES only hashes the first 8000 bytes of input, so similar email messages could end up with the same hash.
Go to Top of Page
   

- Advertisement -