This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
NULLIF
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.
Syntax
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. |
Example
NULLIF('Firebolt fast','Firebolt fast')
Returns: NULL
NULLIF('Firebolt fast','Firebolt Fast')
Returns: Firebolt fast