Monthly Archives: December 2011

Find lower case in case-insensitive SQL

Posted on December 20, 2011 by Job Vermeulen (admin)

To find lowercase values in a case insensitive database run the following query: SELECT * FROM Values CONVERT(varbinary(12), UPPER(Value)) != CONVERT(varbinary(12), Value) It converts the values to binary first before they are compared.

Posted in At the office | Leave a comment