Eine Einführung in

SQL

Replace a NULL with a specific value

SQLite
The SQL standard is COALESCE	SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to SQLite
none

DB2
The SQL standard is COALESCE	SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to DB2
none

MS Access
The SQL standard is COALESCE	SELECT code, name, IIF(ISNULL(leader), 'NO LEADER RECORDED!', leader) FROM party
Specific to MS Access
Use IIF and ISNULL

PostgreSQL
The SQL standard is COALESCE	SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to PostgreSQL
COALESCE takes any number of arguments, it returns the first which is not null.

Oracle
The SQL standard is COALESCE	SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to Oracle
none

MS SQL Server
The SQL standard is COALESCE	SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to MS SQL Server
none

MySQL
The SQL standard is COALESCE	SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to MySQL
none

Sybase
The SQL standard is COALESCE	SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to Sybase
none

Mimer SQL
The SQL standard is COALESCE	SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to Mimer SQL
none