MS Access 2002, problem with case-sensitive query
belgar_31
Dec 28, 2002
1:17 PM |
Evening guys.
I'm sitting here trying to figure out how to get MS access to differentiate between an 'ac' and an 'aC'
I have a field that details a set of bit characters, ranges from 'a' to 'z' and 'A' to 'O' with any combination possible.
I have the query set up as follows:
Under field: w1
Criteria: 'Like "*c"
result: 'ac' 'abc' 'aC' etc
because c and C mean two entirely different things I need only the desired 'c' to be returned..
Any Idea's?
I saw a couple of other threads similar to this, but the answers didn't quite work. for instance Asc([w1] = 99
only checks the first character. 'c' could be anywhere in the list.
|
|
Posting in this forum is limited to members of the group: SITEADMINS, SUBSCRIBERS, MEMBERS.]
|
| If you don't have an account yet, visit the registration page to sign up. If you already have an account, you may login here:
|
|
|
Welcome to the Open Forums!!
|
Welcome to the Open Forums!!
|
|
|