writer
6,694
edits
Changes
Jump to navigation
Jump to search
Created page with "<div style="font-size:30px">'''IFNULL (Value,Default) '''</div><br/> *<math>Value</math> and <math>Default</math> ==Description== *This function used to returned the given ..."
<div style="font-size:30px">'''IFNULL (Value,Default) '''</div><br/>
*<math>Value</math> and <math>Default</math>
==Description==
*This function used to returned the given values according to the Null values.
*In <math>IFNULL (Value,Default)</math>,<math>Value</math> and <math>Default</math> are any two values.This function takes two arguments.
*If the first argument is not NULL, the function returns the first argument. Otherwise, the second argument is returned.
*This function is commonly used to replace NULL value with another value.
==Examples==
# IFNULL(90,3) = 90
# IFNULL(#,54)= 54
# IFNULL("@",1) = @
==See Also==
*[[Manuals/calci/NULL | NULL]]
*[[Manuals/calci/IF | IF]]
*[[Manuals/calci/AVERAGEIF | AVERAGEIF]]
==References==
*[https://www.1keydata.com/sql/sql-ifnull.html IfNull]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
*<math>Value</math> and <math>Default</math>
==Description==
*This function used to returned the given values according to the Null values.
*In <math>IFNULL (Value,Default)</math>,<math>Value</math> and <math>Default</math> are any two values.This function takes two arguments.
*If the first argument is not NULL, the function returns the first argument. Otherwise, the second argument is returned.
*This function is commonly used to replace NULL value with another value.
==Examples==
# IFNULL(90,3) = 90
# IFNULL(#,54)= 54
# IFNULL("@",1) = @
==See Also==
*[[Manuals/calci/NULL | NULL]]
*[[Manuals/calci/IF | IF]]
*[[Manuals/calci/AVERAGEIF | AVERAGEIF]]
==References==
*[https://www.1keydata.com/sql/sql-ifnull.html IfNull]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]