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
This tutorial introduces you to the SQL NULLIF function and shows you how to add the if-else condition to your SQL queries.
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.
NULLIF is equivalent to a searched CASE expression in which the two expressions are equal and the resulting expression is NULL. We recommend that you not use time-dependent functions, such as RAND(), within a NULLIF function.
4 sie 2021 · I want to SELECT column C1 in a way that it converts empty values and N/A to NULL using NULLIF. | C1 |. -------. |NULL |. |NULL |. |apple|. We can do NULLIF(C1, '') which gives NULL if the column value is empty.
15 sty 2021 · SQL NULLIF expression compares two expression and returns a null value if the two specified expressions are equal, else it returns the first expression. NULLIF expression is equivalent to a searched CASE expression in which the two expressions are equal and the resulting expression is NULL.
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)
