How to Sort Rows on a Deterministically Encrypted Column in SQL Server 2016

Data and Databases
1

Using AE in SSMS 2017, ordering rows by a deterministically encrypted column (e.g., surname) triggers an encryption mismatch error. How can I sort the data?

SELECT id, surname
FROM dbo.Employees
ORDER BY surname;
2

hey, have u tried using a computed colum with a decrypted vaue to sort? im curious if this workaround might bypass the error u get. what approaches have others tested on this? lets discuss and see if this helps