Problems creating a SELECT statement

[SelbyGlenn]

Hi there,

I am pretty new to SQL so apologies if this has an obvious answer.

I have a column full of numbers and I want to return all rows where the number in the column = 2 or =3

Can this be done in one SELECT statement?

Thanks in advance,

Glenn
BEng MCSE CCA

 

[JamesLean]

SELECT col
FROM table
WHERE col IN (2, 3)

--James

 

[Golom]

Select * From tbl
Where Fld IN (2, 3)

 

[SelbyGlenn]

Excelent! Thanks guys

Glenn
BEng MCSE CCA