The "Encryptbypassphrase" function transforms the credit card number into an encrypted binary field using the "secret code" password. Read the record with a SQL SELECT statement.

Encrypt a column using Stored procedures So first of all I created a Symmetric key called MY_KEY in my database. If you look under security you will find the place to create the this key.