Miscellaneous functions perform operations on arithmetic, string, or date/time expressions, including the return values of other functions.
Table 5-12 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 does not support these miscellaneous functions.
