Case sensitive SQL queries

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.


Calling a web service from SQL
Case sensitive SQL queries
Connection String Example
Copy ANY TABLE from one database to another
Create (and restore a database to) a TEST server for app testing
Creating a date calendar table
Find table and field a particular value reside
Find tables that have no permissions granted, and fix them
Get a person's age from their birthdate
Get the text of all the triggers in a database
Group by Grouping Sets example
How to format T-SQL
Insert an image into a SQL table from SQL
Log the user that changed a field
Loop through a string and show ASCII characters
Paging query contest
Parsing @tags from a SQL text field
Query that adds a blank like to the result set if the original resultset has more than one line
Remove unwanted characters from a field in SQL
sp_send_dbmail example
SQL code to resequence a grid
SQL Trigger Nest Level
Strip leading zeros
Suppress the results of a stored procedure
Table Value Constructors

... and you 'll find more on the SQL (General) Menu

SELECT i.ITEMNMBR, i.SELNGUOM

FROM iv00101 i

WHERE UPPER(SELNGUOM) <> SELNGUOM COLLATE Latin1_General_CS_AS

UPDATE iv00101 SET SELNGUOM = UPPER(SELNGUOM)

FROM iv00101 i

WHERE UPPER(SELNGUOM) <> SELNGUOM COLLATE Latin1_General_CS_AS

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.

Links
Home
Knowledge Areas
Sitemap

Contact

Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences

Case sensitive SQL queries

Related Articles

... and you 'll find more on the SQL (General) Menu