Simple Case

    This toolbar button will insert the syntax for Case conditional in the SQL pane, for example in the case of MS-SQL Server this string is as follows:

CASE Fld

WHEN when_expression_1 THEN result_expression_1

ELSE else_expression  END

where Fld is the selected field on which the case will be defined, while the dummy-variables when_expression_1, result_expression_1 and else_expression must be edited after this insertion into the SQL pane. Note that the WHEN-phrase may be more than one case, which may be added by the user after the insertion.

Note that the corresponding simple case string in the case of Oracle may utilize the DECODE function, for example, in the following format:

            DECODE(Fld, when_expression_1, result_expression_1, else_expression)