Difference between revisions of "Manuals/calci/IFNULL"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =IFNULL (Value,Default) | + | <div style="font-size:30px">'''IFNULL (Value,Default)'''</div><br/> |
Where | Where | ||
*<math>Value</math> and <math>Default</math> | *<math>Value</math> and <math>Default</math> | ||
| − | + | **IFNULL() used to returned the given values according to the Null values. | |
| − | IFNULL() used to returned the given values according to the Null values. | ||
==Description== | ==Description== | ||
| + | IFNULL (Value,Default) | ||
| − | * | + | *<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. | *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. | *This function is commonly used to replace NULL value with another value. | ||
| Line 16: | Line 16: | ||
# IFNULL("@",1) = @ | # IFNULL("@",1) = @ | ||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=GkdFf-yKxqw|280|center|Null}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 13:55, 11 March 2019
IFNULL (Value,Default)
Where
- and
- IFNULL() used to returned the given values according to the Null values.
and 
Description
IFNULL (Value,Default)
- and 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) = @
Related Videos
See Also
References