What is the workaround for implementing the wildcard search on an encrypted column (using Deterministic approach) in SQL Server 2016?
Have to implement below items in a stored proc being referenced from ASP.NET MVC web app:
- Wildcard search
- Search First Name column using ">=" or "<=" operators