sqlite isnull function example

Example: isnull in sqlite

Syntax
The following illustrates the syntax of the IFNULL function.

IFNULL(parameter_1,parameter_2);
Arguments
The IFNULL function has exactly two arguments.

The IFNULL function is equivalent to the COALESCE function with two arguments. Note that the COALESCE function can have more than two arguments.

Return type
The IFNULL function returns the type of the argument or NULL.