Julie,
Get a copy of Find and Replace by Rick Fisher. The url is below. With it you CAN change all those queries and reports in the Access FE. It's one of the best $37 an Access developer can spend.
http://www.rickworld.com/products.html
You can even download a very functional trial version.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Lynch, Julie K [SMTP:[EMAIL PROTECTED]]
Hello Everyone,
Access 2000 on Windows NT
Oracle 8.1.7.4.0 on HP-UX 11.0 64-bit
Currently both the front end and back end are in Access 2000 and we are
moving the back end to Oracle.
I've got a situation here I'm not sure how to deal with. Does anyone know
how to do case insensitive queries using an Access front end and Oracle back
end? We can't change the Access front end due to the sheer number of select
statements in queries/reports, so I need to somehow get the database to
handle this.
We've got an application that does queries such as:
select * from <table> where name like 'smith'; in one query in Access.
and
select * from <table> where name like 'Smith'; in another query in Access.
and
select * from <table> where name like 'SMITH'; in some other report or
query.
And the data in <table>.name could be SMITH,smith,Smith,sMith,smITH, so on
and so forth.
Is there anyway to get the database to return all records where the name
field contains smith,Smith,SMITH, etc. no matter which of the above queries
is used??
Can't user InterMedia/Oracle Text since we can't change the queries on the
front end.
Function based indexes???
Some how make ODBC convert mixed case like statements to upper or lower
case?
TIA,
Julie
Julie Lynch
Sandia National Laboratories
Oracle 8i DBA - OCP8i
Solaris 2.6,7/HP-UX 11.0 System Administrator
Web Server Administrator