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?

Thanks
Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org