Case Sensitive Data

[henp]

CommentCalls.Code contains codes that are equal but case sensitive. I have linked this table to another table to show description as the original file has none. The problem that I have is that it pulls not only the description for the lower case codes but also for those equal to it in upper case. Can you help?

Thanks,

Kirsten.

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;

 

[KenReay]

Hi

Answered a similar question a few weeks ago, to do with case sensitive comparisons, achieved the result by comparing the asc() of each character.

Immedaiet thought for you problem is to make a query from each table, with a calcualted column which is the asc() of the characters in the join column, then join the two queries on the calculated column

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[mndrlion]

There is a Microsoft Knowledge Base article about this. Here is the link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;244693&Product=acc