Difference between revisions of "Manuals/calci/NULLIF"
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Latest revision as of 03:04, 2 March 2020
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
- NULLIF(25, 25) = 25
- NULLIF('Hello', 'Hello') = Hello
- NULLIF('Hello', 'world') = Hello