SQL Functions for Encrypting and Decrypting Large text fields

After my post about Encrypting Rich Text fields in Power Apps that store their data in SQL server now the promised decryption code in this post as well.