How to Do Case Insensitive Search? – Interview Question of the Week #267


Question: How to Do Case Insensitive Search?

Answer: This is a very interesting question. Most of the time, I receive a question about how to do case sensitive search and I have already previously blogged that in the following blog posts:

How to Do Case Sensitive Search?SQL SERVER – Collate – Case Sensitive SQL Query Search

However, during the recent Comprehensive Database Performance Health Check, I faced a unique situation where the database was case sensitive and our search was needed to be case insensitive. There are multiple ways to do the same but we finally decided to do it with the help