Where Dialog Box

Type directly into the statement box, or use the lists and buttons to build your SQL query.

Finished statement

In this box, add a WHERE clause to your SELECT statement. Specify one or more conditions that must be met for a record to be transferred.

Fields

This box displays the fields in the selected file(s). For more information about a field, hover your mouse over the field name.

Value

Type a value to test against as part of your condition.