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.
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 and2 = 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 |
|
|
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. |
|
|
|
|
|