Link Search Menu Expand Document


Compares two expressions. Returns NULL if the expressions evaluate to equal values. Returns the result of <expr1> if they are not equal. To return <expr2> instead, use IFNULL.


NULLIF(<exp1>, <exp2>)
Parameter Description
<expr1>, <expr2> Expressions that evaluate to any data type that Firebolt supports. The expressions must evaluate to the same data type or synonyms, or an error occurs. The result of <exp1> is returned if the expressions do not evaluate to an equal result.


NULLIF('Firebolt fast','Firebolt fast')

Returns: NULL

NULLIF('Firebolt fast','Firebolt Fast')

Returns: Firebolt fast