IFNULL vs NULLIF in GBase 8a: Why They Are Not Interchangeable

Both IFNULL and NULLIF accept two arguments, but they perform opposite operations. Knowing the difference is key to avoiding subtle data errors. Function Comparison Function Syntax Purpose Logical Equivalent IFNULL IFNULL(expr1, expr2) Replace NULL: if expr1 is NULL , return expr2 ; otherwise return expr1 . CASE WHEN expr1 IS NULL THEN expr2 ELSE expr1 END NULLIF NULLIF(expr1, expr2) Nullify equality: if expr1 equals expr2 , return NULL ; otherwise return expr1 . CASE WHEN expr1 = expr2 THEN NUL