Check out example codes for "isnull in sqlite". It will help you in understanding the concepts better.

Code Example 1

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.

Learn ReactJs, React Native from akashmittal.com