THEN

The result of a WHEN clause when it evaluates to true.

Syntax

WHEN when_expression THEN then_expression

Arguments

when_expression
Any valid Boolean expression.
then_expression
Any valid query expression that returns a collection.

Remark

If when_expression evaluates to the value true, the result is the corresponding then-expression. If none of the WHEN conditions are satisfied, the else-expression is evaluated. However, if there is no else-expression, the result is null.

For an example, see CASE.

Last edited Mar 25, 2013 at 9:51 AM by ansiboy, version 2

Comments

No comments yet.