ISNULL function [Miscellaneous]

Function

Returns the value of the first non-NULL expression in the parameter list.

Syntax

ISNULL ( expression, expression [ …, expression ] )

Parameters

expression An expression to be tested against NULL.

At least two expressions must be passed to the function.

Example

The following statement returns the value -66:

SELECT ISNULL( NULL ,-66, 55, 45, NULL, 16 ) FROM iq_dummy

Usage

The ISNULL function is the same as the COALESCE function.

Standards and compatibility

SQL92 Transact-SQL extension

Sybase Not supported by Adaptive Server Enterprise

See also

“COALESCE function [Miscellaneous]”