Release 10.1A: OpenEdge Data Management:
SQL 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095