Unanswered: Case Sensitive serch using the IN Keyword
I'm new to access (and haven't used SQL in a few years). I have a large dataset that I'm dealing with and I'm trying to to narrow down the results and I want to convert the following query into a case sensitive one:
WHERE code IN ('AAA','BBB','CCC','DDD');
(and I don't want aaa, AaA, etc returned in the results)
From searching it seems like if I had only one thing to search for I'd use
Without excessively using OR's (there are a lot more codes than just the 4 I listed above), is there a way to use StrComp with IN. Or a more efficient way to do a case sensitive search?