Manuals/calci/NULLIF

Revision as of 03:04, 2 March 2020 by Devika (talk | contribs) (Created page with "<div style="font-size:30px">'''NULLIF(Value,Default)'''</div><br/> *<math>Value</math> and <math>Default</math> is any string. ==Description== *The NULLIF function returns a...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
NULLIF(Value,Default)


  • and is any string.

Description

  • The NULLIF function returns a value with the type of the first argument or NULL.
  • This function accepts exactly two arguments.
  • Here two expressions to be compared.
  • If the first argument is not equal to the second one, the NULLIF function returns the first argument.
  • In case both arguments are NULL, the NULLIF function returns a NULL value.

Examples

  1. NULLIF(25, 25) = 25
  2. NULLIF('Hello', 'Hello') = Hello
  3. NULLIF('Hello', 'world') = Hello

See Also

References