Several Criteria Values

Fabio · May 6, 2004

One of my columns has different values from 1 to 30. I
need a criteria for values 1,3,4,6 and 30. How to it?
Thanks in advance, FABIO

RobFMS · May 6, 2004

Assuming each has only 1 value in the column for the record...

Select <column>
From <table>
Where <column> in (1, 3, 4, 6, 30)

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Several Criteria Values

Fabio

RobFMS