Search results
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: SELECT NULLIF('Hello', 'Hello'); Try it Yourself » 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
Besides the COALESCE function, SQL provides you with the NULLIF function which is a control flow function that allows you to test the arguments and returns either the first argument or NULL based on the result of the evaluation.
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. Remarks. NULLIF is equivalent to a searched CASE expression in which the two expressions are equal and the resulting expression is NULL.
26 sie 2021 · I need the data for months 5 to 8 and data where Date1 is NULL Query: select Date1, name from t1 where (month(Date1) <= 8 and month(Date1)>=5) or (month(Date1)=null)
18 lis 2022 · Determining if a function is deterministic. You can check whether a function is deterministic by querying the is_deterministic object property for the function. The example below determines if the function Sales.CalculateSalesTax is deterministic. SELECT OBJECTPROPERTY (OBJECT_ID ('Sales.CalculateSalesTax'), 'IsDeterministic');
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.
The CASE expression is verbose while the NULLIF expression is much shorter and more readable. In this tutorial, you have learned how to use the SQL Server NULLIF expression to return NULL if the first argument equals to the second one.
