SQL Query to Encrypt and Decrypt password in SQL Server

Hi Sadakat,

Refer the below test query.

DECLARE @encrypt VARBINARY(200) 
SELECT @encrypt = ENCRYPTBYPASSPHRASE('key', 'abc')
SELECT @encrypt  'EncryptValue'
SELECT CONVERT(VARCHAR(100),DECRYPTBYPASSPHRASE('key', @encrypt )) 'DecryptValue'

Screenshot