SELECT COALESCE(FIELD, expectValue) FROM t
Equals
SELECT CASE FIELD WHEN IS NULL THEN expectValue ELSE FIELD END FROM t
SELECT COALESCE(FIELD, expectValue) FROM t
Equals
SELECT CASE FIELD WHEN IS NULL THEN expectValue ELSE FIELD END FROM t