Devika: Created page with "
'''NULLIF(Value,Default)'''

* $Value$ and $Default$ is any string. ==Description== *The NULLIF function returns a..."

2020-03-02T08:04:43Z

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..."

New page

<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 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

==See Also==
*[[Manuals/calci/IFNULL | IFNULL ]]
*[[Manuals/calci/IF | IF ]]
*[[Manuals/calci/UPPERCASE | UPPERCASE ]]

==References==
*[https://www.w3schools.com/sql/func_sqlserver_nullif.asp Nullif]

*[[Z_API_Functions | List of Main Z Functions]]

*[[ Z3 | Z3 home ]]

Manuals/calci/NULLIF - Revision history

Devika: Created page with "'''NULLIF(Value,Default)''' *Value and Default is any string. ==Description== *The NULLIF function returns a..."

Devika: Created page with "
'''NULLIF(Value,Default)'''

* $Value$ and $Default$ is any string. ==Description== *The NULLIF function returns a..."