Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 2000 - querying case sensitive data
- Thread starter JJeremy
- Start date
Hi. Access by default will ignore case. Is the A or a the first charachter?
If you convert the first charachter to ascii, A gives 65, and a gives 97, so in a query, if your field is called part, you could do this:
asc(left (part, 1)) <> 65.
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
If you convert the first charachter to ascii, A gives 65, and a gives 97, so in a query, if your field is called part, you could do this:
asc(left (part, 1)) <> 65.
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
- Status
Similar threads
- Locked
- Question
