Loading lesson path
Concept visual
Start at both ends
SELECT NULLIF(25, 25);The NULLIF() function returns NULL if two expressions are equal, otherwise it returns the first expression.
expr1, expr2 )
Description expr1, expr2 Required. The two expressions to be compared
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
SELECT NULLIF('Hello', 'Hello');SELECT NULLIF('Hello', 'world');SELECT NULLIF('2017-08-25', '2017-08-25');❮ SQL Server Functions