Specifying a WHERE Clause

To add a WHERE clause to a query:

Select the Where tab.
On the Fields tab, expand the table node and select the column to use for filtering data.

Tip
You can type in the filter fields text field to locate the column.
Double-click the column or drag it to the SQL expression area.
(Optional) You can click the Functions tab and select the functions to use with filtering.
For character variables, you can click the column-name Values button to select the distinct values of the column. Select and clear the check boxes to specify the values to include in the filter.

Click Apply to add the distinct values to the text area on the right.

Edit the WHERE clause in the SQL expression area as follows:

Number of Values	Edit	Example
One character value	Add an equal sign between the column name and the distinct value.	CARS.Make = 'Acura'
More than one character value	Specify an IN operator and enclose the distinct values in parentheses.	CARS.Make IN ( 'Acura', 'Audi')
Numeric comparison	Specify a numeric operator and a constant, or a numeric operator and another column name.	CARS.Cylinders >= 6 PRDSALE.Actual > PRDSALE.Estimate