Functions

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.


ABS function [Numeric]
ACOS function [Numeric]
ARGN function [Miscellaneous]
ASCII function [String]
ASIN function [Numeric]
ATAN function [Numeric]
ATAN2 function [Numeric]
AVG function [Aggregate]
BYTE_LENGTH function [String]
BYTE_SUBSTR function [String]
CAST function [Data type conversion]
CEILING function [Numeric]
CHAR function [String]
CHAR_LENGTH function [String]
CHARINDEX function [String]
COALESCE function [Miscellaneous]
CONVERT function [Data type conversion]
COS function [Numeric]
COT function [Numeric]
COUNT function [Aggregate]
COUNT_UPLOAD_ROWS function [Aggregate]
DATALENGTH function [System]
DATE function [Date and time]
DATEADD function [Date and time]
DATEDIFF function [Date and time]
DATEFORMAT function [Date and time]
DATENAME function [Date and time]
DATEPART function [Date and time]
DATETIME function [Date and time]
DAY function [Date and time]
DAYNAME function [Date and time]
DAYS function [Date and time]
DB_PROPERTY function [System]
DEGREES function [Numeric]
DIFFERENCE function [String]
DOW function [Date and time]
EXP function [Numeric]
EXPLANATION function [Miscellaneous]
FLOOR function [Numeric]
GETDATE function [Date and time]
GREATER function [Miscellaneous]
HEXTOINT function [Data type conversion]
HOUR function [Date and time]
HOURS function [Date and time]
IFNULL function [Miscellaneous]
INSERTSTR function [String]
INTTOHEX function [Data type conversion]
ISDATE function [Data type conversion]
ISNULL function [Miscellaneous]
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]
ML_GET_SERVER_NOTIFICATION function [System]
MOD function [Numeric]
MONTH function [Date and time]
MONTHNAME function [Date and time]
MONTHS function [Date and time]
NEWID function [Miscellaneous]
NOW function [Date and time]
NULLIF function [Miscellaneous]
PATINDEX function [String]
PI function [Numeric]
POWER function [Numeric]
QUARTER function [Date and time]
RADIANS function [Numeric]
RAND function [Numeric]
REMAINDER function [Numeric]
REPEAT function [String]
REPLACE function [String]
REPLICATE function [String]
RIGHT function [String]
ROUND function [Numeric]
RTRIM function [String]
SECOND function [Date and time]
SECONDS function [Date and time]
SHORT_PLAN function [Miscellaneous]
SIGN function [Numeric]
SIMILAR function [String]
SIN function [Numeric]
SOUNDEX function [String]
SPACE function [String]
SQRT function [Numeric]
ST_AsBinary function [Spatial]
ST_AsExtText function [Spatial]
ST_AsText function [Spatial]
ST_Distance function [Spatial]
ST_Equals function [Spatial]
ST_IntersectsRect function [Spatial]
ST_Point function [Spatial]
ST_PointFromExtText function [Spatial]
ST_PointFromText function [Spatial]
ST_PointFromWKB function [Spatial]
ST_SRID function [Spatial]
ST_X function [Spatial]
ST_Y function [Spatial]
STR function [String]
STRING function [String]
STRTOUUID function [String]
STUFF function [String]
SUBSTRING function [String]
SUM function [Aggregate]
SWITCHOFFSET function [Date and time]
SYNC_PROFILE_OPTION_VALUE function [System]
TAN function [Numeric]
TODATETIMEOFFSET function [Date and time]
TODAY function [Date and time]
TRIM function [String]
TRUNCNUM function [Numeric]
UCASE function [String]
UPPER function [String]
UUIDTOSTR function [String]
WEEKS function [Date and time]
YEAR function [Date and time]
YEARS function [Date and time]
YMD function [Date and time]