Manuals/calci/IFNULL

From ZCubes Wiki
Revision as of 15:31, 5 December 2017 by Devika (talk | contribs) (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 ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

  1. IFNULL(90,3) = 90
  2. IFNULL(#,54)= 54
  3. IFNULL("@",1) = @


See Also


References