The problem that I seem to have with this method is that it does not catch the end of file and leaves it open - so the last part of the string is set filter to .... account_no<>777 and account_no <>

>Something like this:
>
>lccom="set filter to between(date, ldstart, ldend)"
>sele (filter_source)
>scan
>lccom=lccom+" and account # "+alltr(str(numeric_source_field))
>endscan
>
>sele (table_Where_filter_should_be_set)
>&lccom
>
>
>>In regards to multiple filters...I have a table that can be added to (it only contains one field), and it needs to be used as the source for filtering. This table contains account numbers.
>>
>>How can I manipulate Foxpro into using the conditions of that table? For example...manually I code as:
>>
>>set filter to between(date, ldstart, ldend) and account <> 100 ;
>>and account <> 150 and account <> 500 and account <> 100600
>>
>>You get the picture. Any suggestions on how i can get around this? Thanks!