NULL Functions

For certain types of databases, there are expressions that substitute a given value in case a record returns a NULL value. In this way, we have:

For MySQL, the IFNULL(condition, result) or COALESCE(condition, result) functions.

For SQL Server, the ISNULL(condition, result) function.

For Oracle, the NVL(condition, result) function.

For MS Access, the IsNull(condition) function, which we nest in the IIF function.

Interesting article? Share further!

Leave A Comment