I'm using the following code in a form that lets users search multiple fields through delphi's filters to find certain records and display them in a grid.
sContractor := '%' + cbContractor.Text + '%';
sStreetName := '%' + edStreet_Name.Text + '%';
sBuyer := '%' + edBuyer.Text + '%';
with gvresults.DataController.Filter do begin
Root.BoolOperatorKind := fboAND;
if cbContractor.Text <> '' then AddItem(Root,gvResultsContractor, foLike, sContractor , sContractor);
if edStreet_Name.Text <> '' then AddItem(Root,gvResultsStreet_Name, foLike, sStreetName , sStreetName);
if edBuyer.Text <> '' then AddItem(Root,gvResultsBuyer, foLike, sBuyer , sBuyer);
So far I've worked out how to include 'wildcards' in the search, but I haven't worked out how to make the fields ignore the case of the character string entered by user--I assume it needs to be done when the variables are declared though...