What is equivalent of the Nz Function in MS Access in MySQL? Is Nz a SQL standard?

What is MySQL equivalent of the Nz Function in Microsoft Access? Is Nz a SQL standard?

In Access, the Nz function lets you return a value when a variant is null. Source

The syntax for the Nz function is:

Nz ( variant, [ value_if_null ] )

Answer

The COALESCE() function does what you describe. It’s standard SQL and it should be supported in all SQL databases.

The IFNULL() function is not standard SQL. Only some brands of databases support this function.