What is MySql equivalent of the Nz Function in MS 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 ] )
views:
2022answers:
2
+1
A:
You might want to look at IFNULL or COALESCE. If I recall correctly, IFNULL works for mySQL.
Mike Wills
2008-10-21 20:16:26
IFNULL is the equivalent for mysql.
Jamie Love
2008-10-21 20:20:03
+3
A:
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.
Bill Karwin
2008-10-21 21:24:47
The question is about MS Access, which support neither COALESCE() nor IFNULL().
onedaywhen
2008-10-22 07:26:03
That came out wrong: MS Access does not support COALESCE() nor IFNULL() but MySQL does, which *is* what the question is about. I regret my aside :)
onedaywhen
2008-10-22 07:28:51