You
can use the Expression Builder wizard to replace expressions
or subqueries that you have defined.
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).
Prerequisite: The
SQL statement must be open in the SQL Query Builder.
To replace an expression:
- In
the Design pane of the SQL Query Builder, double-click the cell in
which you want to replace the expression.
- Click Replace
Expression in the list. The Expression Builder
wizard opens.
- Select the type of expression
that you want to replace the existing
expression, and then click Next.
- Specify information for the fields in the wizard, and then
click Finish.