Saravanan V

Saravanan V

  • NA
  • 997
  • 330.6k

Wildcard search on Encrypted column using Always Encrypted

Sep 18 2017 10:57 AM

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