Case insensitive join

  • Thread starter Thread starter Bob Peskin
  • Start date Start date
B

Bob Peskin

How can do a case-insensitive join on 2 tables in Access 2k.

Example of keys are:
210(,dk
210(,Dk
210(,dK
and Access query builder sees these as being the same value.
 
Ooops, little problem with my expression. This is
updated...

format(asc(Left(strdata, 1)),"000") & format(asc(mid
(strData, 2, 1)),"000") & format(asc(mid(strData, 3,
1)), "000") & format(asc(mid(strData, 4, 1)), "000") &
format(asc(mid(strData, 5, 1)), "000") & format(asc(mid
(strData, 6, 1)),"000") & format(asc(mid(strData, 7,
1)), "000")
 
Back
Top