Hi All,
I am hacking some data in Access (which I rarely use). I've noticed that the SQL is
not case sensitive on alpha fields. e.g.
select x.*, y.*
from x left join y on x.key = y.key
gives me
x.key y.key
A A
A a
wher both A and a exist in table y.
How can you make this SQL case sensitive ?
Regards
Andrew
---------------------------------------------------------------------------
New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
