I got a new problem with Oracle running under Solaris.
I would like to retrieve information giving the value of a column, so this is with: " select * where X = 'YYYY' ", but the where clause may ignore the case of the condition, so 'yyyy' will be as valid as 'YYYY' or 'YyYy'.
If you have Oracle 9i, you can build a 'function based index' on this column to help performance. Of course, the best solution is to ensure the data is entered into the database in one case only at the start. This can be done with database triggers or through the application.