If you're using LIKE, rather than =, you can use %. WHERE cSalesP LIKE '%' will return all the records.
>I have a view to join tables. I also have been using the ?CSalesP in the Filter condition. Is there a value I can assign to CsalesP so All records are joined and visible at one time. I thought the "*" was to deactivate the Filter, but it did not work today?
>
>
dmk@iname.com