SQL
zoo.net
Replace a NULL with a specific value
SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
Access
The SQL standard is
COALESCE
SELECT code, name, IIF(ISNULL(leader), 'NO LEADER RECORDED!', leader) FROM party
Specific to Access
Use IIF and ISNULL
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.