Function Name | Syntax |
|---|---|
+ | expression + expression |
- | expression - expression |
/ | expression / expression |
< | expression < expression |
<= | expression <= expression |
<> | expression <> expression |
= | expression = expression |
> | expression > expression |
>= | expression >= expression |
AND | boolean_expression AND boolean_expression |
AVG | AVG (expression) |
BETWEEN | BETWEEN (test_expression, begin_expression, end_expression) |
CASE WHEN...THEN...ELSE...END | CASE WHEN (boolean_expression) THEN (result_expression) [...n] [ELSE (else_result_expression)] END |
CASE...WHEN...THEN...ELSE...END | CASE (input_expression) WHEN (when_expression) THEN (result_expression) [...n] [ELSE (else_result_expression)] END |
CAST...AS | CAST (expression AS data_type) |
CONCAT | CONCAT (expression, expression[,expression...]) |
CONVERT | CONVERT (data_type [( length)], expression[, style]) |
COUNT | COUNT (expression) |
DATEADD | DATEADD (datepart, number, expression) |
DATEDIFF | DATEDIFF (datepart, startdate, enddate) |
DATEPART | DATEPART (datepart, date) |
DISTINCT | DISTINCT (column) or DISTINCT column |
GETDATE | GETDATE () |
IF...THEN...ELSE...END | IF (boolean_expression) THEN (true_expression) [ELSE (false_expression)] END |
IIF | IIF (boolean_expression, true_expression, [false_expression]) |
ISNULL | ISNULL (check_expression, replacement_value) |
LEN | LEN (expression) |
MAX | MAX (expression) |
MIN | MIN (expression) |
OR | boolean_expression OR boolean_expression |
ROUND | ROUND (expression, length[, function]) |
RUNNING AVG | RUNNINGAVG (column) |
RUNNING COUNT | RUNNINGCOUNT (column) |
RUNNING SUM | RUNNINGSUM (column) |
SUM | SUM (expression) |
