SQL NULL Functions
Handling NULL values.
SQL NULL Functions
SQL ISNULL(), NVL(), IFNULL() and COALESCE() functions are used to handle NULL values.
Suppose that the "UnitsOnOrder" column is optional, and may contain NULL values.
We want to calculate: UnitsInStock + UnitsOnOrder. If explicitly NULL, the result would be NULL.