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

[Michael \(michka\) Kaplan [MS]]

Only if the database is case-insensitive.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Jan Bols" <ja*@ivpv.ugent.be> wrote in message
news:bo**********@gaudi2.UGent.be...

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

[Peter Doering]

On Wed, 05 Nov 2003 14:59:03 +0100, Jan Bols wrote:

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?

I always use pass-through queries and clauses like e.g.
WHERE UPPER(FieldName) LIKE '%XYZ%'

Peter

--
No mails please.