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) + '%")))');

Using D4 and DBIsam 2.12 and a horse and a buggy.

Jerry

Jerry

I don't know if I understood but...

Sql.Clear;
Sql.Add('select * from table where upper(field) like '%'+
AnsiUpperCase(Edit1.Text)+'%');
Open;

Eduardo