ISNULL Vs NULLIF

Friday, 17 August 2012

ISNULL Vs NULLIF


ISNULL:
ISNULL ( expression , replacement)
Replaces NULL with the specified replacement value. It returns the value of expression if it is not null.


NULLIF:
NULLIF( expression , expression)
It returns a null value if both the expression is equal. NULLIF returns the first expression if both the expression is not equal.

No comments:

Post a comment