Date: 12/23/04 (SQL Server)    Keywords: mysql, database, sql, postgresql

cross-posted to databases

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?

Source: http://www.livejournal.com/community/sqlserver/13063.html