Manuals/calci/IFNULL - Revision history

Devika: /* Examples */

2019-03-11T18:55:57Z

Examples

Devika at 19:42, 24 August 2018

2018-08-24T19:42:40Z

Devika: /* Description */

2018-01-04T20:47:18Z

Description

Devika at 20:45, 4 January 2018

2018-01-04T20:45:51Z

Devika: Created page with "
'''IFNULL (Value,Default) '''

* $Value$ and $Default$ ==Description== *This function used to returned the given ..."

2017-12-05T20:31:50Z

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 ..."

New page

<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 ]]

← Older revision		Revision as of 18:55, 11 March 2019
Line 16:		Line 16:
	# IFNULL("@",1) = @		# IFNULL("@",1) = @

		+	==Related Videos==
		+
		+	{{#ev:youtube\|v=GkdFf-yKxqw\|280\|center\|Null}}

	==See Also==		==See Also==

@@ Line 1: / Line 1: @@
-=IFNULL (Value,Default) =
+<div style="font-size:30px">'''IFNULL (Value,Default)'''</div><br/>
 Where
 *<math>Value</math> and <math>Default</math>
+**IFNULL() used to returned the given values according to the Null values.
 ==Description==