Encryption functions

Encryption functions encrypt or decrypt VARCHAR or BINARY values.

FunctionNotes
ENCRYPTEncrypts VARCHAR or BINARY values using a passphrase.
DECRYPTDecrypts VARCHAR or BINARY values using a passphrase.
TRY_DECRYPTError-handling version of DECRYPT.
ENCRYPT_RAWEncrypts BINARY values using a binary key and an initialization vector.
DECRYPT_RAWDecrypts BINARY values using a binary key and an initialization vector.
TRY_DECRYPT_RAWError-handling version of DECRYPT_RAW.