SQL Functions Overview

String Functions

CHARINDEX
CONCAT
LEN
LOWER
UPPER
REPLACE
SUBSTRING
TRIM

Date & Time Functions

GETDATE
DATEADD
DATEDIFF
DATEPART
CONVERT

Mathematical Functions

ABS
CEILING
FLOOR
POWER
ROUND
SQRT

Aggregate Functions

AVG
COUNT
MAX
MIN
SUM
STDEV