>>>I'm trying to filter a query with WHERE clause so it finds certain states in a column. How do I do this? Something like this:
>>>
>>>SELECT * FROM table WHERE Bts=0 AND Ost = ('PA','NY')
>>>
>>>only selects PA.
>>
>>

>>SELECT * FROM table WHERE Bts=0 AND Ost  in  ('PA','NY')
>>

>
>
>Thanks. When I try this, I get "Function name is missing )".
>
>SELECT * FROM table WHERE Bts=0 AND Ost in ('PA','NY','NJ','MD','DE') AND Dst in ('WA','OR',CA')
>
>
>EDIT: I tried this and it seems to have worked:
>
>inlist(Ost,'PA','NJ','NY','MD','DE') AND inlist(Dst,'WA','OR','CA')

What is your VFP version? I believe IN worked for quite a while, but may be it was brought to VFP SQL language few versions ago.