CODE EXAMPLE FOR SQL

SQL server ignore case in a where expression

SELECT * FROM myTable WHERE myField = 'sOmeVal' COLLATE SQL_Latin1_General_CP1_CI_AS