In article <54D6DDE4C19@...>, Myles Wakeham wrote:

> What is the best practice for doing Case Insensitive searches on CHAR
> fields? We have a query where I need to provide a search on a partial match
> (ie. 'LIKE' or 'CONTAINS' type search) but the search information entered
> could be any mix of upper and/or lower case, but the data in the tables
> could also be in any format.
>
> What is the easiest way to handle this?

Have an additional field, maintained by trigger, that forces all contents
to one case and search against that

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly