Restrictions on Using a Value Expression

A value expression can be composed of any of the items described in Value Expression, but with the following restrictions:

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

For information on the limitations of using value expressions that are aggregate functions, see the section on "Aggregate Functions" in Functions Used in The Select List .