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