CASE value-expr { WHEN value-expr THEN value-expr } ... [ ELSE value-expr ] END Matches two value expressions for equality. This clause is identical to the SQL SIMPLE CASE expression.