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