Search results
Example. Compare two expressions: SELECT NULLIF(25, 25); Try it Yourself » Definition and Usage. The NULLIF () function returns NULL if two expressions are equal, otherwise it returns the first expression. Syntax. NULLIF (expr1, expr2) Parameter Values. Technical Details. More Examples. Example. Compare two expressions:
- Try It Yourself
Edit the SQL Statement, and click "Run SQL" to see the...
- The Try-SQLSERVER Editor
Edit the SQL Statement, and click "Run SQL" to see the...
- Try It Yourself
The NULLIF function will convert any column value with only whitespace into a NULL value. Works for T-SQL and SQL Server 2008 & up. SELECT [column_name] FROM [table_name] WHERE NULLIF([column_name], '') IS NULL
The SQL NULLIF function is used to compare two expressions or values and return NULL if they are equal. It provides a way to handle specific cases where you want to treat equality as a special condition by substituting it with a NULL value.
SQL NULLIF examples. The following statement returns NULL because 100 is equal to 100. SELECT NULLIF (100, 100); Code language: SQL (Structured Query Language) (sql) The following statement returns 100 because 100 is less than 200, the NULLIF function returns the first argument which is 100.
The following example creates a budgets table, loads data, and uses NULLIF to return a null if current_year is null or contains the same data as previous_year.
SQL Server NULLIF expression overview. The NULLIF expression accepts two arguments and returns NULL if two arguments are equal. Otherwise, it returns the first expression. The following shows the syntax of the NULLIF expression: NULLIF(expression1, expression2) Code language: SQL (Structured Query Language) (sql)
16 mar 2024 · SQL provides several functions to handle these values more gracefully, allowing for cleaner data presentation and more robust calculations. In this article, we'll explore how to use ISNULL, NULLIF, and COALESCE with practical examples.
