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
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.
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. Transact-SQL syntax conventions. Syntax NULLIF ( expression , expression ) Arguments. expression
You would use the SQL NULLIF function when you want to replace a value with NULL in your query result if it matches a specified condition. NULLIF is particularly useful when you need to handle equality as a distinct case, such as when you want to hide or suppress certain results in your query.
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.
8 maj 2022 · SQL NULLIF () Explained. Most major RDBMS s support the NULLIF() operator, which returns NULL if both of its arguments are equivalent. If the arguments not equivalent, NULLIF() returns the first argument. NULLIF() is a SQL-standard feature (it’s included in the ISO/IEC 9075 specification).
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)
