IFNULL

Syntax

IFNULL(expr1,expr2) NVL(expr1,expr2)

Description

If expr1 is not NULL, IFNULL() returns expr1; otherwise it returnsexpr2. IFNULL() returns a numeric or string value, depending on the context in which it is used.

NVL() is an alias for IFNULL().

Examples

SELECT IFNULL(1,0);  +-------------+ | IFNULL(1,0) | +-------------+ | 1 | +-------------+  SELECT IFNULL(NULL,10); +-----------------+ | IFNULL(NULL,10) | +-----------------+ | 10 | +-----------------+  SELECT IFNULL(1/0,10); +----------------+ | IFNULL(1/0,10) | +----------------+ | 10.0000 | +----------------+  SELECT IFNULL(1/0,'yes'); +-------------------+ | IFNULL(1/0,'yes') | +-------------------+ | yes | +-------------------+

See Also

• NULL values

• IS NULL operator

• IS NOT NULL operator

• COALESCE function

• NULLIF function

• CONNECT data types

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}