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]
• CONFLICT 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]
• GREATER function [Miscellaneous]
• IDENTITY function [Miscellaneous]
• IFNULL function [Miscellaneous]
• INDEX_ESTIMATE function [Miscellaneous]
• ISNULL function [Miscellaneous]
• LESSER function [Miscellaneous]
• NEWID function [Miscellaneous]
• NULLIF function [Miscellaneous]
• NUMBER function [Miscellaneous]
• PLAN function [Miscellaneous]
• REWRITE function [Miscellaneous]
• ROW_NUMBER function [Miscellaneous]
• SQLDIALECT function [Miscellaneous]
• SQLFLAGGER function [Miscellaneous]
• TRACEBACK function [Miscellaneous]
• TRANSACTSQL function [Miscellaneous]
• VAREXISTS function [Miscellaneous]
• WATCOMSQL function [Miscellaneous]