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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Case Sensitive Keys 2
Case Sensitive Query 7
Case Sensitive Key? 3
Access Query - Union of TEXT files that are selected. 8
Assistance with calling UDF from a query 6
case-sensitive Left Join 1
updating a table based on data in same table 2
Differentiating Case Sensitivity in a Vlookup 4

Back
Top