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.