ASA SQL Reference
  SQL Functions
    Function types

Miscellaneous functions

Miscellaneous functions perform operations on arithmetic, string or date/time expressions, including the return values of other functions.

List of functions 

The following miscellaneous functions are available:

• ARGN function [Miscellaneous]

• COALESCE function [Miscellaneous]

• ERRORMSG function [Miscellaneous]

• ESTIMATE function [Miscellaneous]

• ESTIMATE_SOURCE function [Miscellaneous]

• EXPERIENCE_ESTIMATE function [Miscellaneous]

• EXPLANATION function [Miscellaneous]

• EXPRTYPE function [Miscellaneous]

• GET_IDENTITY function [Miscellaneous]

• GRAPHICAL_PLAN function [Miscellaneous]

• GRAPHICAL_ULPLAN function [Miscellaneous]

• GREATER function [Miscellaneous]

• IDENTITY function [Miscellaneous]

• IFNULL function [Miscellaneous]

• INDEX_ESTIMATE function [Miscellaneous]

• ISNULL function [Data type conversion]

• LESSER function [Miscellaneous]

• LONG_ULPLAN function [Miscellaneous]

• NEWID function [Miscellaneous]

• NULLIF function [Miscellaneous]

• NUMBER function [Miscellaneous]

• PLAN function [Miscellaneous]

• REWRITE function [Miscellaneous]

• SHORT_ULPLAN function [Miscellaneous]

• SQLDIALECT function [Miscellaneous]

• TRACEBACK function [Miscellaneous]

• TRANSACTSQL function [Miscellaneous]

• VAREXISTS function [Miscellaneous]

• WATCOMSQL function [Miscellaneous]