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
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.
The NULLIF function will convert any column value with only whitespace into a NULL value. Works for T-SQL and SQL Server 2008 & up. SELECT [column_name] FROM [table_name] WHERE NULLIF([column_name], '') IS NULL
1 paź 2024 · Dowiedz się, co to jest SQL NULLIF, jaką ma składnię i zastosowanie. Wyjaśniamy na przykładzie użycia w BigQuery.
The NULLIF function is equivalent to the following searched CASE expression: CASE WHEN argument_1 = argument_2 THEN NULL ELSE argument_1 END;Code language:SQL (Structured Query Language)(sql) The expression returns NULL if two arguments are equal, otherwise, it returns the argument_1.
8 maj 2022 · The NULLIF() function is basically a syntactical shortcut for the CASE expression. So for example, we could replace the previous example with the following: SELECT Name, LocalName FROM country WHERE Region = 'South America' AND (CASE WHEN LocalName = Name THEN NULL ELSE LocalName END) IS NOT NULL ORDER BY Name; Result:
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)
