Loading lesson path
Concept visual
Start at both ends
Return the specified value IF the expression is NULL, otherwise return the expression:
SELECT ISNULL(NULL, 'W3Schools.com');The ISNULL() function returns a specified value if the expression is NULL. If the expression is NOT NULL, this function returns the expression.
expression, value )
Required. The expression to test whether is NULL value
Required. The value to return if expression is NULLSQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Return the specified value IF the expression is NULL, otherwise return the expression:
SELECT ISNULL('Hello', 'W3Schools.com');Return the specified value IF the expression is NULL, otherwise return the expression:
SELECT ISNULL(NULL, 500);❮ SQL Server Functions