Case Sensitive Data

[henp]

Please help,

I have a querie that uses a table of codes to read a linked file. The problem I'm having is that some of the codes can be both sM and sm of course these codes are unchangeable. Is there a simple way to change either my table or my querie to recognise the difference.

Thanks

Kirsten.

 

[RobSchultz]

Try this:

SELECT * FROM codeTable WHERE StrComp([codeName],"sM",0)=0;

HtH,

Rob

-Focus on the solution to the problem, not the obstacles in the way.-

 

[henp]

Hey Rob

Thanks for your reply only I have many codes that use both upper and lowercase such AB aB not just sm and sM is there not a way to have my querie use my table to read my linked file exactly as it was inputted.

Here's the queries I'm using

SELECT Commentcalls.Code, Commentcalls.ClientID, Count(Commentcalls.Code) AS CountOfCode, ConsumerCodes2.Field2
FROM Commentcalls INNER JOIN ConsumerCodes2 ON Commentcalls.Code = ConsumerCodes2.Codes
GROUP BY Commentcalls.Code, Commentcalls.ClientID, ConsumerCodes2.Field2;

Thanks