How to make Access differentiate capital letter "A" and normol letter "a" in que

[Thinh Nguyen]

Hi all,
In my table, I used some letters in Capital and normal
form. Then when I used the letters as parameters in a
query, I found out Access cannot differentiate "A"
and "a". Can anybody help me with this.
Many thanks

 

[Douglas J. Steele]

StrComp("A", "a", vbBinaryCompare) or StrComp("A", "a", 0) returns -1, while
StrComp("A", "a", vbTextCompare) or StrComp("A", "a", 1) returns 0.

 

[Guest]

You could also set the ascii equivalent and see if its above or below a capital
number range. Or see if the letter = ucase(letter)
If not, it's lower case

[email protected]