Matching case

[mmitchell]

I have two tables that have fields set to a text so that the ClientID is their name.

When I query, my queries don't take into account the case. So "K Smith" is the same as "K SMITH" as "k sMIth"

I am trying to write an unmatched query between two tables based on this ClientID but it will turn up no unmatched because it is not taking into account the case.

Any suggestions on how to match the cases, othere then changing the table?

Thanks.

 

[Alc]

Haven't tried it myself, but maye this thread willl help:
http://www.access-programmers.co.uk...p?t=58990&highlight=case-sensitive+comparison