THE WORLD'S LARGEST WEB DEVELOPER SITE
HTML CSS JAVASCRIPT SQL PHP BOOTSTRAP HOW TO JQUERY W3.CSS ANGULARJS XML MORE FORUM EXAMPLES REFERENCES

SQL Server NULLIF() Function

❮ SQL Server Functions

Example

Compare two expressions:

SELECT NULLIF(25, 25);
Try it Yourself »

Definition and Usage

The NULLIF() function compares two expressions.

If expr1 and expr2 are equal, the NULLIF() function returns NULL. Otherwise, it returns expr1.

Syntax

NULLIF(expr1, expr2)

Parameter Values

Parameter Description
expr1, expr2 Required. The two expressions that will be compared (must be of same data type)

Technical Details

Works in: SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005

More Examples

Example

Compare two expressions:

SELECT NULLIF('Hello', 'Hello');
Try it Yourself »

Example

Compare two expressions:

SELECT NULLIF('Hello', 'world');
Try it Yourself »

Example

Compare two expressions:

SELECT NULLIF('2017-08-25', '2017-08-25');
Try it Yourself »

❮ SQL Server Functions