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