Case sensitivity in queries

[midnight]

I'm running queries based on the TWK ratings. A typical rating would look like: "C5b". The problem is in the TWK's rated "B". running Like "*B*" also picks up the "b" on the end (breezing).

Is there a way to run the query so that the capital B is used and the small b is ignored? I know that I can run it in multi forms such as *B3* and *B4* and *B5*, but is there a convenient way to run a case-sensitive query asking for just "B"?

[Rick]

Access doesn't appear to be very case sensitive.

You could try something like b??

If what you are looking for is it to start with b.

[Donnie]

Doing a b* would bring back all fields that start with "b" but not those fields that end with "b"

[midnight]

Thanks.