AbrahamA
4Penny.net
Points: 7375

2/27/2024 7:48:00 AM

Case sensitive SQL queries

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

I have an issue in a database where the unit of measure schedules are sometimes upper case, sometimes lower, sometimes mixed. I'm about to lose my mind...

I need a query that will display the offenders and fix them. 

COLLATE Latin1_General_CS_AS to the rescue.

4Penny.net
Version: Unknown or N/A
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3