Craig, a followup if I may, while your example starts me off ther's a slight twist. I want to check for blank entries in the given fields so I get only the records that have ~values~ in 1 of 12 char fields:

SET FILTER TO .not. INLIST(" ", statmnt_dt,stat_date1,stat_date2,stat_date3,;
stat_date4,stat_date5,stat_date6,stat_date7,stat_date8,stat_date9,stat_dat10,;
stat_dat11,stat_dat12)
but this doesn't seem to work





>>>
>>>SET FILTER TO INLIST("paid", state1, state2, ...state19) ;
>>> OR INLIST("paid", state20, state21, ...state30)
>>>
>>>You need multiple INLISTS because the limit is 24.
>>
>>So you'd need to copy the result of the first statement to another dbf and perform the next 'inlist' upon that?
>
>You can do it with one SET FILTER with multiple INLIST().