Replace NULL with fallback value

sql

SELECT COALESCE(phone, mobile_phone, 'N/A') AS preferred_phone
FROM contacts;

Explanation

COALESCE is portable and common across SQL engines.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Conditional, NULL, and Conversion Functions

Return NULL when two expressions are equal.

Open In sheetsqlsame section

Return different values based on conditions.

Open In sheetsqlsame section

Cast an expression to a different type.

Open In sheetsqlsame section

Join multiple strings into one value.

Return the current date and current timestamp.

Count unique entries in a column.