Does anyone know how to encrypt a string using Transact SQL?

Thanks!
Bob