Defining conditions for SQL statements in the SQL Query Builder

A search condition specifies a condition that is true, false, or unknown about a given row or group. The result of a search condition is derived by application of the specified logical operators (AND, OR, NOT) to the result of each specified predicate. If logical operators are not specified, the result of the search condition is the result of the specified individual predicate.

Before you begin

You specify conditions for an SQL statement in a WHERE clause or a HAVING clause. Use the WHERE clause in SELECT, UPDATE, and DELETE statements to specify conditions for rows. You can define WHERE clauses in the SQL Query Builder on the Conditions page of the Design pane. Use the HAVING clause in a SELECT statement to specify conditions for groupings. You can define HAVING clauses in the SQL Query Builder on the Group Conditions page of the Design pane.

Restriction: The use of parentheses in conditions is not supported.

Before you begin, the SQL statement must be open in the SQL Query Builder.

Procedure

To define a condition for an SQL statement in the SQL Query Builder:

  1. In the Design pane of the SQL Query Builder, click the tab for the type of condition that you are defining:
    • If you are defining the condition for a row, click the Conditions tab.
    • If you are defining the condition for a grouping, click the Group Conditions tab.
  2. Double-click the first empty cell under the Column heading and select a column or type the expression for the condition. You can also click Build Expression in the list and use the Expression Builder wizard to create a complex expression.
  3. Double-click the adjoining cell under the Operator heading and select an operator for the condition.
  4. Double-click the adjoining cell under the Value heading and select a column or type a value or expression. A value is typically a numeric or string constant or a host variable. You can also select Build Expression in the list and use the Expression Builder wizard to create a complex expression.

Feedback