ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the first non-NULL expression in the parameter list.
ISNULL ( expression, expression [ , ... ] )
expression An expression to be tested against NULL.
At least two expressions must be passed into the function.
SQL/92 Transact-SQL extension.
SQL/99 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise, except that Adaptive Server Enterprise allows only two expressions.
COALESCE function [Miscellaneous]
The following statement returns the value -66.
SELECT ISNULL( NULL ,-66, 55, 45, NULL, 16 )