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
This tutorial introduces you to the SQL NULLIF function and shows you how to add the if-else condition to your SQL queries.
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)
Transact-SQL syntax conventions. Syntax NULLIF ( expression , expression ) Arguments. expression Is any valid scalar expression. Return Types. Returns the same type as the first expression. 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 ...
8 maj 2022 · NULLIF() is a SQL-standard feature (it’s included in the ISO/IEC 9075 specification). Syntax. The syntax goes like this: NULLIF (V1, V2) This is equivalent to the following CASE expression: CASE WHEN V1=V2 THEN NULL ELSE V1 END Example. Here’s an example to demonstrate: SELECT NULLIF( 12, 12 ); Result: NULL
Syntax. The syntax for the SQL NULLIF function is as follows: NULLIF(expression1, expression2) expression1: The first expression or value you want to compare. expression2: The second expression or value you want to compare to expression1.
11 kwi 2024 · The syntax for the NULLIF() function is as follows: NULLIF(value1, value2) If value1 equals value2, NULLIF() returns NULL: NULLIF( 'foo', 'foo' ) Run query. If values are not equal, the NULLIF() function returns value1: NULLIF( 'foo', 'bar' ) Run query. Using NULLIF() to prevent errors.
