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).
Prerequisite: The SQL statement
must be open in the SQL Query Builder.
About this task
To
create an expression:
- In the Design
pane of the SQL Query Builder, double-click the
cell in which you want to create the expression.
- Click Build
Expression in the list
and then press Enter. The Expression Builder
wizard opens.
- Select the type of expression
that you want to build, and
then click Next.
- Specify
information for the fields in the wizard, and then
click Finish.