Skip to main content

By specifying column-level collation as Latin1_General_BIN, you can perform case sensitive comparisons of your data.

-- Simple column comparison
select <column>
from <table>
where <column> COLLATE Latin1_General_BIN = 'CaseSensitiveValue';

-- Regex comparison
select <column>
from <table>
where <column> COLLATE Latin1_General_BIN LIKE '[a-z]';