Replace a NULL with specific value

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

Use IIF and ISNULL

COALESCE takes any number of arguments, it returns the first which is not null.

Functions

Concatenate strings

Extracting substrings

lower case

Finding Substring

Formatting numbers

Replace NULL

Conditional values

Time now

Format dates