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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
?StrComp("ABC", "abc",vbBinaryCompare)
-1

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

Check Access VB Help on the StrComp() function.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top