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.

Before you begin

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

The SQL statement must be open in the SQL Query Builder.

Procedure

To create an expression:

  1. In the Design pane of the SQL Query Builder, double-click the cell in which you want to create the expression.
  2. Click Build Expression in the list and then press Enter. 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.

Feedback