Skip to content

Instantly share code, notes, and snippets.

@dejanstojanovic

dejanstojanovic/Case insensitive SELECT

Created February 20, 2015 09:40
Show Gist options
  • 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