Hi John

$ cannot be rushmore optimized. It would be a little better if you did ...

cSearch = upper(alltrim(m.cSearch))
SET FILTER TO cSearch $ alltrim(upper(name))

This goes for the SQL suggested by Manoj too.

>I am using the following code to set a filter of a table which then display the results in a list box.
>
>SET FILTER TO ALLTRIM(UPPER(csearch)) $ ALLTRIM(UPPER(Name)) IN Customer
>
>If there is only one record that matches the filter it works ok but if there are more that one a wait window pops up saying Filter cleared and the list box goes grey.
>
>Any ideas.
>
>Also the above code is not rush more optimised is there a better way.
>
>John