VistaDB 5
NULLIF

NULLIF( expression, expression)

Returns a null value if the two specified expressions are equal.

Returns the same type as the first expression.

Example

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. 
See Also