SQL
zoo.net
Replace a NULL with a specific value
SQLite
DB2
Ingres
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
DB2
The SQL standard is
COALESCE
SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to DB2
none
Related links:
FUNCTIONS
Concatenate strings.
Substring: Extracting part of a string.
lower case
Finding a substring in a string
Formatting numbers to two decimal places.
Replace a NULL with a specific value
Conditional values
Get the date and time right now.
Format dates.