Image

Imagelinearb wrote in Imagesqlserver

MD5 support in SQL Server 2000

cross-posted to Imagedatabases

For privacy protection within an application, I hash email addresses into MD5. MySQL, PostgreSQL, and Oracle all have a scalar function that allows you to hash a column/string -- for example MD5(emailaddr).

I have yet to find such a function, or a handy library/package for creating such a function in SQL Server 2000. Did I miss something? recommendations?