The smartest way to do "multiple or" with SQL?

[Jaymond Flurrie]

Let's say we have 51 categories for Area, like, say, the states of USA. Now my programs wants to select all the people that lives in states that my user selected. Let's say those are "AR", "CO", "CA", "WY" or "HI". So far this is simple, right?

Now the part where I stick my finger into my mouth is that how do I do this in an SQL query? Hardcoding 51 OR-categories sounds more than stupid, and in my real problem I can't even know if there 1, 5, 15 or 51 of those "OR-categories".

Do we have some "is on the list"-operator in SQL? Can I just pass a typical VBA-array there?

 

[dk]

Hi

You can use the IN operator e.g.

SELECT * FROM MYTABLE WHERE STATE IN ("AR", "CO", "CA", "WY","HI")


HTH
DK

 

[Jaymond Flurrie]

Hi

You can use the IN operator e.g.

SELECT * FROM MYTABLE WHERE STATE IN ("AR", "CO", "CA", "WY","HI")


HTH
DK

Much better, thanks!