Use this tab to restrict the rows in your result set.

Components

Criteria   Use the Criteria pane to enter your WHERE conditions. You can type directly into this pane, or use the Expression Editor. To edit existing expressions, highlight the expression before you open the Expression Editor. Otherwise, what you create in the Expression Editor is appended to previously existing expressions.

Build WHERE expression   Click the Add a Computed Column button, located in the bottom right of the Criteria pane, to open the Expression Editor and build your WHERE condition.

Results   Click Results at the bottom of the window to see the results of your query, or an error message if the query contains errors.

SQL   Click SQL at the bottom of the window to see the SQL code for your query.

See also

• For more information about the Query Editor, see Query Editor introduction.
• For an introduction to search conditions, see The WHERE clause: Specifying rows.
• For more information about search conditions, see Search conditions.