Difference between revisions of "Manuals/calci/IFNULL"

Latest revision as of 12:55, 11 March 2019

IFNULL (Value,Default)

Where

IFNULL (Value,Default)

$Value$ and $Default$ 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.

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''IFNULL (Value,Default) '''</div><br/>
+<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==
-*This function used to returned the given values according to the Null values.
+IFNULL (Value,Default)
-*In <math>IFNULL (Value,Default)</math>,<math>Value</math> and <math>Default</math> are any two values.This function takes two arguments.
+*<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.
@@ Line 14: / Line 16: @@
 # IFNULL("@",1) = @
+==Related Videos==
+{{#ev:youtube|v=GkdFf-yKxqw|280|center|Null}}
 ==See Also==