SELECT ... WHERE value = 1 or 203 or 300 or 4000

Hi,

I want to display a small number of results (rows of data) from a table where the Variable “value” has the number 1, 203, 300 or 4000.

How can I do this with the SELECT statement?

Thanks,

Matt

WHERE value = 1 OR value = 203 OR value = 300 OR value = 4000

or more compact way:

WHERE value IN (1, 203, 300, 4000)

Thanks for that - the second method is easier. Thanks again.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.