Both the standard valued and searched CASE expressions are supported. In both cases, the ELSE expression is optional and, if not specified, the expression will return NULL if no WHEN conditions evaluate to TRUE. At least one WHEN/THEN condition is required with both forms of CASE expression, and a test expression is also required with the valued form.
Double-click on Case to show all of the available functions and operators.
The following figure shows the Case functions available when connected to a Teradata database.
The following figure shows the Case functions available when connected to an Aster database.