VistaDB 6
VistaDB / Developer's Guide / SQL Reference / Functions / System Functions / NULLIF
In This Topic
    NULLIF
    In This Topic

    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