IF...ELSE Blocks

If Else Blocks are incredibly simple and can be rather helpful at times. This is the general syntax.

IF [Boolean Expression]
   BEGIN
  Print 'in if'
END
ELSE
  IF [Boolean Expression]
   BEGIN
  PRINT 'in else'
END