Manuals/calci/IFNULL
Jump to navigation
Jump to search
IFNULL (Value,Default)
- and
Description
- This function used to returned the given values according to the Null values.
- In , 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) = @
See Also
References