Case insensitive filter in MS Access front end

[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