How do I set up a case sensitive check in an Access select query?

D

devichml

I have a column in a table in an access database with mixed upper and lower
case characters. When I run a select query against this data, I want to be
able
to identify values such as ABC, abc, AbC, ... as being different.
 
V

Van T. Dinh

?StrComp("ABC", "abc",vbBinaryCompare)
-1

?StrComp("ABC", "ABC",vbBinaryCompare)
0

Check Access VB Help on the StrComp() function.

HTH
Van T. Dinh
MVP (Access)
 
Top