Quick Tip: Use Hashbytes to create a Hash from TSQL in SQL 2005

Just a quick tip, SQL Server 2005 has built in support for creating SHA1 and MD5 hashes from within TSQL code and the function is called HashBytes!