locked
Query Language - isnull() equivalent RRS feed

  • Question

  • Hi,

    is there any "workaround" for the isnull() function to replace missing values with a default?

    Thanks,


    Thomas Pagel

    Friday, May 20, 2016 7:37 PM

Answers

All replies

  • Will this work?

    SELECT CASE WHEN x is NULL THEN 'default value' ELSE x END as x
    FROM input

    Friday, May 20, 2016 7:50 PM
  • OMG... This was way to obvious to find out myself... ;-) Thanks! I'll give it a try...

    Thomas Pagel

    Saturday, May 21, 2016 10:18 AM