Search results
The NULLIF() function returns NULL if two expressions are equal, otherwise it returns the first expression. Syntax
- 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
For example, SELECT NULLIF(4,4) AS Same, NULLIF(5,7) AS Different; returns NULL for the first column (4 and 4) because the two input values are the same. The second column returns the first value (5) because the two input values are different.
10 cze 2023 · The SQL NULLIF function lets you compare two values and determine if they match or not: Match? The function will return NULL. Don’t match? The function will return the first value. Syntax and Parameters. The syntax of the SQL NULLIF function is: NULLIF (expr1, expr2) The parameters of the NULLIF function are:
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.
4 sie 2021 · I have a column C1 with values that can either be 'values' or 'empty' or 'N/A'. I want to SELECT column C1 in a way that it converts empty values and N/A to NULL using NULLIF. We can do NULLIF(C1, '') which gives NULL if the column value is empty.
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 Server NULLIF examples. Let’s take some examples of using the NULLIF expression. Using NULLIF expression with numeric data examples. This example returns NULL because the first argument equals the second one: SELECT NULLIF (10, 10) result; Code language: SQL (Structured Query Language) (sql) Here is the output:
