How do I search for a string regardless of case? The following code
will find 'abc' or 'ABC' but not 'Abc' unless that is exactly how it is
entered in the edit box.
sql.add('WHERE (((Z4Items.Title LIKE "%'+ SSS + '%"))');
sql.add('OR ((Z4Items.Title LIKE "%' + uppercase (SSS) + '%")))');