Skip to content

Instantly share code, notes, and snippets.

@bennadel

bennadel/code-1.sql

Created March 25, 2014 00:35
Show Gist options
  • Save bennadel/9752615 to your computer and use it in GitHub Desktop.
Save bennadel/9752615 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server Text Matching Is Case INSENSITIVE
Raw
code-1.sql
SELECT
id
FROM
address
WHERE
street1 = '123 Street St'
SELECT
id
FROM
address
WHERE
street1 = '123 STREET ST'
SELECT
id
FROM
address
WHERE
street1 = '123 StReEt sT'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment