THE WORLD'S LARGEST WEB DEVELOPER SITE

SQL Server ISNULL() Function

❮ SQL Server Functions

Example

Return the specified value IF the expression is NULL, otherwise return the expression:

SELECT ISNULL(NULL, 'W3Schools.com');
Try it Yourself »

Definition and Usage

The ISNULL() function returns a specified value if the expression is NULL.

If the expression is NOT NULL, this function returns the expression.

Syntax

ISNULL(expression, value)

Parameter Values

Parameter Description
expression Required. The expression to test whether is NULL
value Required. The value to return if expression is NULL

Technical Details

Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

More Examples

Example

Return the specified value IF the expression is NULL, otherwise return the expression:

SELECT ISNULL('Hello', 'W3Schools.com');
Try it Yourself »

Example

Return the specified value IF the expression is NULL, otherwise return the expression:

SELECT ISNULL(NULL, 500);
Try it Yourself »

❮ SQL Server Functions