Two nearly identical brass keys lying side by side on a workbench, one cut with a single notch in a different place.

SQL SERVER – Collate – Case Sensitive SQL Query Search

Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.

SQL Authority with Pinal Dave
120 Comments