CASE_N ( conditional_expression [,...] [, case_spec ] )
Syntax Elements
- conditional_expression
- An expression or comma-separated list of condition expressions to evaluate.
- case_spec
-
{ NO CASE [ { OR | , } UNKNOWN ] | UNKNOWN }
- NO CASE
- Evaluates to TRUE if every conditional_expression in the list evaluates to FALSE.
- { OR | , } UNKNOWN
- The NO CASE OR UNKNOWN condition evaluates to TRUE if every conditional_expression in the list evaluates to FALSE, or if a conditional_expression evaluates to UNKNOWN and all prior conditions in the list evaluate to FALSE.
- UNKNOWN
- Evaluates to TRUE if a conditional_expression evaluates to UNKNOWN and all prior conditions in the list evaluate to FALSE.