Contents Index ISDATE function [Data type conversion] ISNUMERIC function [Miscellaneous]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

ISNULL function [Data type conversion]


Function 
Syntax 

ISNULL ( expressionexpression [ , ... ] )

Parameters 

expression    An expression to be tested against NULL.

At least two expressions must be passed into the function.

Standards and compatibility 
See also 

COALESCE function [Miscellaneous]

Example 

The following statement returns the value -66.

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

Contents Index ISDATE function [Data type conversion] ISNUMERIC function [Miscellaneous]