Progress
SQL-92
Guide and Reference


CONDITIONAL EXPRESSION

CASE EXPRESSION

A type of conditional expression.

SYNTAX
case_expr ::=
searched_case_expr | simple_case_expr 

SEARCHED CASE EXPRESSION

SYNTAX
searched_case_expr ::=
CASE
  WHEN search_condition THEN { result_expr | NULL } [ , ... ]
[ ELSE expr | NULL ]
END 

SIMPLE CASE EXPRESSION

SYNTAX
simple_case_expr ::=
CASE primary_expr
  WHEN expr THEN { result_expr | NULL } [ , ... ]
[ ELSE expr | NULL ]
END 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095