Expression Builder wizard - Expression Types page

Use this page to select the type of expression that you want to create.

You can create one of the following types of expressions:

Function
A function expression is denoted by a function name and any parameters required. The function runs an operation and returns a value.
CASE
A CASE expression causes an expression to be selected based on the evaluation of one or more conditions.
CAST
A CAST expression converts an instance of a data type into an instance of a different data type.
Constant
A constant expression specifies a value such as a string or a number.
Subquery
A subquery expression is a SELECT, WITH, or FULLSELECT statement that typically returns a single value to use as an expression within another SQL statement.
Build up expressions by operators
An expression that is built by applying operators to columns or expressions.
Related tasks
Creating expressions in the Expression Builder wizard
Editing expressions in the Expression Builder wizard
Replacing expressions in the Expression Builder wizard
Related reference
Expression Builder wizard - Function Builder page
Expression Builder wizard - CASE Options page
Expression Builder wizard - CAST Builder page
Expression Builder wizard - Constant Options page
Expression Builder wizard - Subquery page
Expression Builder wizard - Expressions by Operators page

Feedback