13 Replies Latest reply: Aug 6, 2009 7:30 AM by 421084 RSS

    NULL in CASE statement

    421084
      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;