Encrypt/Decrypt data from within SQL server using a pass phrase

SQL server has two functions EncryptByPassPhrase and DecryptByPassPhrase which encrypt/decrypt data with a passphrase using a TripleDES algorithm with a 128 bit key.

EncryptByPassPhrase - http://technet.microsoft.com/en-us/library/ms190357.aspx