Sometimes It's The Little Things That Count (2)

Starting with the Panorama beta, ENDIF and END IF can be used interchangeably, as can END CASE versus END, in expressions and statements.

Can I have a "Woohoo!" please?

SELECT IF dummy_col = 0
          THEN 'zero'
          ELSE 'not zero'
       END IF AS a,

       IF dummy_col = 0
          THEN 'zero'
          ELSE 'not zero'
       ENDIF AS b,

       CASE dummy_col
          WHEN 0 THEN 'zero'
          ELSE 'not zero'
       END CASE AS c,

       CASE dummy_col
          WHEN 0 THEN 'zero'
          ELSE 'not zero'
       END AS d;

IF 0 = 0 THEN
   MESSAGE 'zero';
ELSE
   MESSAGE 'not zero';
END IF;

IF 0 = 0 THEN
   MESSAGE 'zero';
ELSE
   MESSAGE 'not zero';
ENDIF;

CASE
   WHEN 0 = 0 THEN
      MESSAGE 'zero';
   ELSE
      MESSAGE 'not zero';
END CASE;

CASE
   WHEN 0 = 0 THEN
      MESSAGE 'zero';
   ELSE
      MESSAGE 'not zero';
END;