How would one go about doing a case-insensitive search on a column encrypted with Always Encrypted?
The problem arises when you encrypt email addresses for example.
When encrypted, John.Doe@gmail.com != john.doe@gmail.com
Is the best solution truly to duplicate the encrypted column with the ToLower version of the text to search against?
