Hi,

So what's faster, I have tried to read on the benefit/drawback of using
Where Query vs Filter but nothing that puts the clock straight.

I did this in my app using filters so instead of using then SQLWhere ...

IB_QueryCompany.Filtered := False;
if (EditSearch.Text <> '') then
begin
case ComboSearchType.ItemIndex of
0: IB_QueryCompany.Filter := 'COMPANY_NAME LIKE ''' + EditSearch.Text
+ '%''';
1: IB_QueryCompany.Filter := 'COMPANY_NAME LIKE ''%' + EditSearch.Text
+ '%''';
end;
IB_QueryCompany.Filtered := True;
end;

Emptying the Edit field will show all.

Thanks