Miscellaneous functions perform operations on arithmetic, string, or date/time expressions, including the return values of other functions.
Table 4-16 lists the miscellaneous functions and their parameters.
Miscellaneous functions |
Parameters |
|---|---|
ARGN |
( integer-expr, expression [ , … ) |
COALESCE |
( expression, expression [ , expression … ] ) |
IFNULL |
( expression1, expression2 [ , expression3 ] ) |
ISNULL |
( expression, expression [ , expression … ] ) |
NULLIF |
( expression1, expression2 ) |
NUMBER |
( * ) |
ROWID |
( table-name ) |
Adaptive Server Enterprise supports only the COALESCE, ISNULL, and NULLIF functions.
