Manuals/calci/IFNULL

Revision as of 15:45, 4 January 2018 by Devika (talk | contribs)

IFNULL (Value,Default)

Where

  •   and  

IFNULL() used to returned the given values according to the Null values.

Description

  • 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