What is the use of the NULLIF function?

Started by Devlin, November 21, 2015, 09:31:11 PM

Previous topic - Next topic

Rafferty

Hi everyone, I'd like to ask you a silly question, what is the use of the nullif function? Thank you for giving me your opinion quickly.

Cohen

NULLIF compares expr1 and expr2 . If they are equal, then the function returns null. If they are not equal, then the function returns expr1.