13 Replies Latest reply on Aug 6, 2009 12:30 PM by Shawn Michaels

    NULL in CASE statement

    Shawn Michaels
      back again, . . .
      does anyone have any idea on how to handle null values in a case statement?

      CASE column
      WHEN NULL THEN 'value'
      WHEN 'value2' THEN 'valuexx'
      ELSE 'othervalue'
      END;