CODE EXAMPLE FOR SQL

encrypt and decrypt in sql server

select [dbo].[CLR_Encrypt]('Lorem ipsum.')
select [dbo].[CLR_Decrypt]('9HNOlWhgkAF1tjC0FJX6pdyIKfQ2rHbI6Uiku7jK0ZY=')