Click the

Source Columns

tab.

In the

Table

list, select the table for which you want to define a WHERE clause for filtering column data.

Right-click a column row for which to add a condtition in a WHERE clause and click the button in the

Column Condition

column.

In the

Operator

list, select one of the following comparison operators: =, <>, <, >, >=, <=, IS NULL, IS NOT NULL, LIKE, or BETWEEN.

In the

Value

field, enter a value to use with the operator.

If you want to add another condition for the same column, select the

OR

check box. Then define another condition for the current column.

If you want to add a condition for another column, select one of the following options in the

Operator for next column

list to determine if the conditions for one or both columns must be true to filter data. Options are:

Click

OK

.

On the

Source Columns

tab, verify the WHERE clause that you defined for the table columns by clicking

Show Where

.