ASA SQL Reference

SQL Functions

Alphabetical list of functions

ISNULL function [Data type conversion]

Function 

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

Syntax 

ISNULL ( expression, expression [ , ... ] )

Parameters 

expression    An expression to be tested against NULL.

At least two expressions must be passed into the function.

Standards and compatibility 

• SQL/92    Transact-SQL extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise, except that Adaptive Server Enterprise allows only two expressions.

See also 

• COALESCE function [Miscellaneous]

Example 

The following statement returns the value –66.

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

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.