SQL functions (E-O)

Each function is listed, and the function type (numeric, character, and so on) is indicated next to it.

For links to all functions of a given type, see Function types.

See also

ENCRYPT function [String]
ERRORMSG function [Miscellaneous]
ESTIMATE function [Miscellaneous]
ESTIMATE_SOURCE function [Miscellaneous]
EVENT_CONDITION function [System]
EVENT_CONDITION_NAME function [System]
EVENT_PARAMETER function [System]
EXP function [Numeric]
EXPERIENCE_ESTIMATE function [Miscellaneous]
EXPLANATION function [Miscellaneous]
EXPRTYPE function [Miscellaneous]
FIRST_VALUE function [Aggregate]
FLOOR function [Numeric]
GET_BIT function [Bit array]
GET_IDENTITY function [Miscellaneous]
GETDATE function [Date and time]
GRAPHICAL_PLAN function [Miscellaneous]
GREATER function [Miscellaneous]
GROUPING function [Aggregate]
HASH function [String]
HEXTOINT function [Data type conversion]
HOUR function [Date and time]
HOURS function [Date and time]
HTML_DECODE function [Miscellaneous]
HTML_ENCODE function [Miscellaneous]
HTTP_DECODE function [HTTP]
HTTP_ENCODE function [HTTP]
HTTP_BODY function [HTTP]
HTTP_HEADER function [HTTP]
HTTP_VARIABLE function [HTTP]
IDENTITY function [Miscellaneous]
IFNULL function [Miscellaneous]
INDEX_ESTIMATE function [Miscellaneous]
INSERTSTR function [String]
INTTOHEX function [Data type conversion]
ISDATE function [Data type conversion]
ISNULL function [Miscellaneous]
ISNUMERIC function [Miscellaneous]
LAST_VALUE function [Aggregate]
LCASE function [String]
LEFT function [String]
LENGTH function [String]
LESSER function [Miscellaneous]
LIST function [Aggregate]
LOCATE function [String]
LOG function [Numeric]
LOG10 function [Numeric]
LOWER function [String]
LTRIM function [String]
MAX function [Aggregate]
MIN function [Aggregate]
MINUTE function [Date and time]
MINUTES function [Date and time]
MOD function [Numeric]
MONTH function [Date and time]
MONTHNAME function [Date and time]
MONTHS function [Date and time]
NCHAR function [String]
NEWID function [Miscellaneous]
NEXT_CONNECTION function [System]
NEXT_DATABASE function [System]
NEXT_HTTP_HEADER function [HTTP]
NEXT_HTTP_VARIABLE function [HTTP]
NEXT_SOAP_HEADER function [SOAP]
NOW function [Date and time]
NULLIF function [Miscellaneous]
NUMBER function [Miscellaneous]