Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » Query Editor Help

INTO tab Next Page

WHERE tab


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

Dialog 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.

Expression Editor    Click the Calculator icon, 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 dialog to see the results of your query, or an error message if the query contains errors.

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

More information