Ric Sierra (3/22/2010)
this undocumented function is available since SQLServer 7
PWDENCRYPT is a hash function, which means it's a one-way function. Once hashed, data cannot be restored. With cell-level encryption, data can be both encrypted and decrypted.