Encrypt a large rich text field in SQL Stored Procedures

Recently I have done a lot of work with SQL Stored Procedures in Power Apps. But what do you do if you want to have some fields encrypted in your SQL database. In this post how to Encrypt and decrypt using stored procedures.