Skip to content

Instantly share code, notes, and snippets.

@dejanstojanovic

dejanstojanovic/Case insensitive SELECT

Created February 20, 2015 09:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dejanstojanovic/751b65703493446ecd64 to your computer and use it in GitHub Desktop.
Save dejanstojanovic/751b65703493446ecd64 to your computer and use it in GitHub Desktop.
Download ZIP
Perform case insensitive SELECT in Microsoft SQL Server
Raw
Case insensitive SELECT
SELECT * FROM myTable WHERE myField = 'sOmeVal' COLLATE SQL_Latin1_General_CP1_CI_AS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment