T-SQL Encryption Query Code Problems

[Deknoid]

Hello.

 

I'm currently working on a table residing in a database (called dbo.Customers), where from the table itself I need to take two variables which are "CVV" and "CreditCard" and column-level encrypt them using T-SQL.

 

I've been searching online to try and find a solution on the internet, but the result was unsuccessful. 

 

Do please note that this is a question from an assignment, and no actual data is being worked on.

 

 

Thank you