Replace a NULL with specific value

From SQLZOO
Jump to: navigation, search

Replace a NULL with a specific value

schema:gisq

The SQL standard is COALESCE



SELECT code, name,
    IIF(ISNULL(leader),
        'NO LEADER RECORDED!',
        leader)
  FROM party
SELECT code, name,
    COALESCE(leader, 'NO LEADER RECORDED!')
  FROM gisq.party
SELECT code, name,
    COALESCE(leader, 'NO LEADER RECORDED!')
  FROM party