Manuals/calci/NULLIF

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