String Functions

String Functions - CAST | CAST_STR_AS_INT | CAST_STR_AS_DECIMAL | CHAR | CHARINDEX |
CHARINDEXSTD | COALESCE | CONCAT | CSTR | ENDSWITH | INSERT | ISNULL | ISNULLOREMPTY | LEFT |
LEN | LCASE | LTRIM | REMOVE | REPLACE | REVERSE | RIGHT | RTRIM | SUBSTRING | STARTSWITH | TRIM
| UCASE

Date Functions - CDATE | DATE | GETDATE | DATEADD | DATEDIFF | DATEDIFFMILLISECOND | DATEPART |
DATESERIAL | DAY | DAYOFWEEK | MONTH | TRUNC | YEAR

Math - ABS | CAST_NUM_AS_BYTE | CAST_NUM_AS_DECIMAL | CAST_NUM_AS_DOUBLE
| CAST_NUM_AS_INT | CAST_NUM_AS_LONG | CAST_NUM_AS_SHORT | CAST_NUM_AS_SINGLE | FLOOR |
LOG | MAX | MAXLIST | MIN | MINLIST | POWER | RAND | ROUND | SIGN | SQRT

Trigonometric - ASIN | ACOS | ATAN | ATAN2 | COS | COSH | SIN | SINH | TAN | TANH

Aggregate Functions - MIN | MAX | COUNT | AVG | SUM | COUNT ( DISTINCT() ) | MINLIST | MAXLIST

Statistical Functions - STDEV| STDEVP | VAR | VARP