https://wiki.zcubes.com/index.php?title=Manuals/calci/NULLIF&feed=atom&action=historyManuals/calci/NULLIF - Revision history2024-03-29T09:29:01ZRevision history for this page on the wikiMediaWiki 1.35.2https://wiki.zcubes.com/index.php?title=Manuals/calci/NULLIF&diff=212985&oldid=prevDevika: 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..."2020-03-02T08:04:43Z<p>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..."</p>
<p><b>New page</b></p><div><div style="font-size:30px">'''NULLIF(Value,Default)'''</div><br/><br />
*<math>Value</math> and <math>Default</math> is any string.<br />
<br />
==Description==<br />
*The NULLIF function returns a value with the type of the first argument or NULL.<br />
*This function accepts exactly two arguments.<br />
*Here two expressions to be compared.<br />
*If the first argument is not equal to the second one, the NULLIF function returns the first argument. <br />
*In case both arguments are NULL, the NULLIF function returns a NULL value.<br />
<br />
==Examples==<br />
#NULLIF(25, 25) = 25<br />
#NULLIF('Hello', 'Hello') = Hello<br />
#NULLIF('Hello', 'world') = Hello<br />
<br />
==See Also==<br />
*[[Manuals/calci/IFNULL | IFNULL ]]<br />
*[[Manuals/calci/IF | IF ]]<br />
*[[Manuals/calci/UPPERCASE | UPPERCASE ]]<br />
<br />
==References==<br />
*[https://www.w3schools.com/sql/func_sqlserver_nullif.asp Nullif]<br />
<br />
*[[Z_API_Functions | List of Main Z Functions]]<br />
<br />
*[[ Z3 | Z3 home ]]</div>Devika