case Sensitive compare

[Rover]

I have a field x. I want to write a query and compare it to a literal
"1a" but I DON'T want that to compare equal to "1A" (Case Sensitive).
How do I do that?

TIA

Jim

 

[Douglas J. Steele]

You'll have to use the StrComp function. Instead of

WHERE Field1 = "1a"

use

WHERE StrComp([Field1], "1a", 0) = 0

Note that this will be noticably slower than simply doing a comparison.

 

[Rover]

Thanks!