Hi Janusz

Found the solutions and used the following code for filtering with the correct result.
When the user enters 'weert' in the edit box and hits the enter key the code below
is executed and gives me all cities with the string 'weert'

 dmTables.tbl_plaats.Filter:='wpl_naam like '+QuotedStr('%'+lowercase(RzButtonEdit_wplZoek.Text)+'%');
 dmTables.tbl_plaats.Filtered:=true;

Yes, that's it. Also, it seems to me you can use any function (also Pos())
in callback filter to separate a record subset.

Janusz


U¿ytkownik "peter van mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:7469C414-7D15-43F1-9997-E5E86E2A35A0@news.elevatesoft.com...
> Hi Janusz
>
> Found the solutions and used the following code for filtering with the
> correct result.
> When the user enters 'weert' in the edit box and hits the enter key the
> code below
> is executed and gives me all cities with the string 'weert'
>
>  dmTables.tbl_plaats.Filter:='wpl_naam like
> '+QuotedStr('%'+lowercase(RzButtonEdit_wplZoek.Text)+'%');
>  dmTables.tbl_plaats.Filtered:=true;
>

peter


You're nearly there The expression you want is

dmTables.tbl_plaats.Filter:='LOWER(wpl_naam) like LOWER('+QuotedStr('%'+RzButtonEdit_wplZoek.Text+'%') +')';
 dmTables.tbl_plaats.Filtered:=true;

That ensure that it catches everything regardless of case.

Roy Lambert