How to Encrypt/Decrypt the passward in SQL Server..?

DECLARE @Name VARCHAR(100) = 'RAJU'
DECLARE @EncName VARCHAR(500)

SELECT  EncryptByPassphrase('A',@Name) EncryptByPassphrase

OutPut
======
0x010000001AB718D8402648B2CCD2C46DACFCDF7844ADD7243B8C9ECA


SELECT @EncName = EncryptByPassphrase('A',@Name)

SELECT CAST(DecryptByPassphrase('A', @EncName) AS VARCHAR(100)) DecryptByPassphrase

OutPut
======
RAJU