SQL ISNULL(), NVL(), IFNULL() and COALESCE ... - W3Schools

NET Oracle, Access, SQL Server. ... In the example above, if any of the " UnitsOnOrder" values are NULL, the result is NULL. ... In MySQL we can use the IFNULL() function, like this:.

www.w3schools.com