NULLIF( expression, expression)
Returns a null value if the two specified expressions are equal.
Returns the same type as the first expression.
NULLIF Examples |
Copy Code
|
---|---|
SELECT NULLIF( 1, 0); This would return 1 since the first column is 1 and the two expressions do not match. SELECT NULLIF( 0, 0); This would return NULL because the two values are equal. |