Access Query - Case Sensitive

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

Could anyone please tell me how you can make access do a
case senitive query. I have trying to run a query on a
unique ID symbol, but Access 2000 is saying that Få is
the same as få and FÅ, this is happening to all the ID's.

Thanks you anyone who can help

Anthony
 
Could anyone please tell me how you can make access do a
case senitive query. I have trying to run a query on a
unique ID symbol, but Access 2000 is saying that Få is
the same as få and FÅ, this is happening to all the ID's.

Hi Anthony,

If you are trying to do a case-sensitive join,
the following may help:

HOWTO: Perform a Case-Sensitive JOIN Through Microsoft Jet
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q244693

The method that is updateable and can be partly optimizable:

SELECT Table1.ID, Table1.Description
FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID
WHERE StrComp(Table1.ID, Table2.ID, 0) = 0;

Please respond back if I have misunderstood.

Good luck,

Gary Walter
 
Back
Top