Case insensitive filter in MS Access front end

  • Thread starter Thread starter Jan Bols
  • Start date Start date
J

Jan Bols

I'm using Oracle 8.1.7 on a linux server. I'm using ms access 2002 as a
front end to connect to the dbserver with the oracle ODBC driver on a
win2k machine.

When I use the filter functionality inside MS Access to look up a
record, the result is case-sensitive (I guess because oracle itself is
case-sensitive).

Is there a way that I can use the filter inside MS Access to look up
records in a case-insensitive way?

Jan Bols
 
Jan Bols said:
I'm using Oracle 8.1.7 on a linux server. I'm using ms access 2002 as a
front end to connect to the dbserver with the oracle ODBC driver on a
win2k machine.

When I use the filter functionality inside MS Access to look up a
record, the result is case-sensitive (I guess because oracle itself is
case-sensitive).

Is there a way that I can use the filter inside MS Access to look up
records in a case-insensitive way?
Click to expand...

Not using the simple filter tools built into Access, but you can easily do
this in a query or in the advanced filter grid. Instead of a filter like..

[SomeField] = "SomeTextString"

use...

UCase([SomeField]) = "SOMETEXTSTRING"
or
UCase([SomeField]) = UCase("SomeTextString")
 
Back
Top