Case sensitivity in Access SQL queries
Posted on 2006-10-20
I have an SQL query that compares a field in an Access table ("uom") that resides in a separate mdb file, to a corresponding field in a linked table ("dbo_uom") that's in a Sybase database.
SELECT uom_id FROM uom IN 'd:/access/newdvlp_266/custom/ImportUtility_Workfile_2002.mdb' WHERE EXISTS (SELECT 1 FROM dbo_uom WHERE dbo_uom.uom_id = uom.uom_id)
The purpose of this query is to find uom_id's in the local table that have duplicates in the Sybase table.
We can have all sorts of combinations of cases in these tables; in other words, we might have:
I'm not sure how to make this query case-sensitive. I've seen other solutions that work by making both items being compared lower-case, but that's kind of the opposite of what I'm looking for. If I've got "UMOL" in my local table, I only want the query to return "UMOL", not "umol" or "Umol".
Thanks very much for any help you can provide!