CASE WHEN boolean_expression THEN result_value ; [ WHEN boolean_expression THEN result_value ; ]... [ ELSE result_value ; ] END CASE ;