Definition and Usage The NULLIF () function returns NULL if two expressions are equal, otherwise it returns the first expression. Syntax NULLIF (expr1, expr2)

Nov 18, 2025 · NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression.

In this tutorial, you will learn how to use the SQL NULLIF function to compare two values and return NULL if they are equal.

Jul 23, 2025 · The NULLIF () function simplifies SQL queries by reducing the need for complex conditional logic using CASE statements. It is commonly used to prevent errors such as division by …

Purpose NULLIF compares expr1 and expr2. If they are equal, then the function returns null. If they are not equal, then the function returns expr1. You cannot specify the literal NULL for expr1.

Nov 9, 2023 · Learn the syntax of the nullif function of the SQL language in Databricks SQL and Databricks Runtime.

This tutorial introduces you to the SQL Server NULLIF expression and gives you some practical examples of using the NULLIF expression.

Reference Function and stored procedure reference Conditional expression NULLIF Categories: Conditional expression functions NULLIF Returns NULL if expr1 is equal to expr2, otherwise returns …

Apr 7, 2025 · If you want to check data and return a NULL value, you can use the NULLIF function. If you want to check for a NULL value and return a different value, use the ISNULL function.

This tutorial shows you how to use the Oracle NULLIF function with syntax and practical examples.