You can select all the rows that contain any value in a set of values. Enclose the values in parentheses and separate one value from the next with a comma. A blank between values is optional. (You can not specify NULL in a set of values.)
In the following query, the condition IN (20, 38, 42) in the DEPTNUMB column means "select every row with a department number of 20, 38, or 42." It is equivalent to, but simpler than, writing the condition _D=20 OR _D=38 OR _D=42.
When you run this query:
Q.ORG | DEPTNUMB | DEPTNAME | ------+-----------------+----------| P. | IN (20, 38, 42) | | |
QMF produces this report:
DEPTNUMB DEPTNAME
-------- ---------------
20 MID ATLANTIC
38 SOUTH ATLANTIC
42 GREAT LAKES