To encrypt and decrypt the password in SQL Server

VALUES(@User_Id,@User_Name,EncryptByPassPhrase('User_Password', @User_Password ))
 
string strSQL = "select * from User_Login where User_Name ='" + uname + "' AND decryptbypassphrase('User_Password',User_Password) ='" + password + "'";