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
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.
14 lis 2013 · On SQL Server, you can convert an empty string to a numeric type. Even though you are expecting an error, your output will be 0 . To understand what is happening, try this fiddle demo :
The following example creates a budgets table, loads data, and uses NULLIF to return a null if current_year is null or contains the same data as previous_year.
10 cze 2023 · The NULLIF function checks two values and returns either the first value or NULL. The ISNULL function will replace a value with a different value if the first value is NULL. ISNULL is available in SQL Server and MySQL, but not Oracle or Postgres. In MySQL, ISNULL returns either 1 or 0.
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.
Using NULLIF expression with character string data example. The following example uses the NULLIF expression. It returns NULL because the first character string is equal to the second one: SELECT NULLIF ('Hello', 'Hello') result; Code language: SQL (Structured Query Language) (sql) Here is the output:
