Creating expressions in the Expression Builder wizard

You can use the Expression Builder wizard to create complex expressions or subqueries. An expression specifies a value. It can be a simple value, consisting of only a constant or a column name, or it can be more complex.

You can start the Expression Builder wizard from anywhere in the SQL builder where you can use an expression in a statement (for example, the Column column in the Design pane of a SELECT statement).

Prerequisite: The SQL statement must be open in the SQL builder.

To create an expression:

  1. In the Design pane of the SQL builder, double-click the cell in which you want to create the expression.
  2. Click Build Expression in the list. The Expression Builder wizard opens.
  3. Select the type of expression that you want to build, and then click Next.
  4. Specify information for the fields in the wizard, and then click Finish.
Related tasks
Specifying FULLSELECT statements in the SQL builder
Defining conditions for SQL statements in the SQL builder
Creating GROUP BY clauses in the SQL builder
Related reference
SQL builder for FULLSELECT statements
Conditions page
Groups page
SQL builder Design pane - Set page
Columns page
Expression Builder wizard - Expression Types page
Expression Builder wizard - Function Builder page
Expression Builder wizard - CASE Options page
Expression Builder wizard - Searched CASE Expression page
Expression Builder wizard - Simple CASE Expression page
Expression Builder wizard - CAST Builder page
Expression Builder wizard - Constant Options page
Expression Builder wizard - Numeric Constant Builder page
Expression Builder wizard - String Constant Builder page
Expression Builder wizard - Subquery page
Expression Builder wizard - Expressions by Operators page

Feedback