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.