>>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')