SQL SERVER – Collate – Case Sensitive SQL Query Search

In this blog post we are going to learn about how to do Case Sensitive SQL Query Search.

If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records.