Provides conditional execution of statements based on the equality of two operands (simple CASE statement) or the value of a conditional expression (searched CASE statement).
The CASE statement is different from the SQL CASE expression, which returns the result of an expression.
ANSI Compliance
CASE is ANSI/ISO SQL:2011-compliant.
Required Privileges
None.
Invocation
Executable
Stored procedures only.