Select List Expressions

You can use expressions in the select list of SELECT statements. A select list can now consist of the following items:

• Column Identifiers
• Functions
• Literals (For example, 1234, 'somestring')
• Numeric expressions (For example, x + y)
• Logical expressions (For example, x AND y)

Restrictions on Select List Expressions

An expression in a select list can be composed of any of the previous items with the following restrictions:

• Functions must be supported by ActiveSpaces.
• A select list cannot contain an expression, if it also contains an aggregate function.
• An expression cannot contain an aggregate function.
• Expressions cannot contain parameters.
• Expressions cannot contain SELECT statements.
• Nested expressions are limited to a depth of 100.