<p>What is MySQL equivalent of the <code>Nz</code> Function in Microsoft Access? Is <code>Nz</code> a SQL standard?</p>

<p>In Access, the <code>Nz</code> function lets you return a value when a variant is null. <a href="http://www.techonthenet.com/access/functions/advanced/nz.php" rel="nofollow noreferrer">Source</a></p>

<p>The syntax for the <code>Nz</code> function is:</p>

<pre><code>Nz ( variant, [ value_if_null ] )
</code></pre>

You might want to look at
```
IFNULL
```
or
```
COALESCE
```
. If I recall correctly,
```
IFNULL
```
works for MySQL.