Function expressions

Syntax

Any built-in can be used as an expression. The syntax for a function call is the name of a function followed by its argument list in parentheses.

function ( [expression [, expression...]] )

Arguments

function

Any built-in function. For some example functions, see SQL functions reference.

expression

Any expression(s) matching the data type and parameter count expected by the function.

Examples

abs (variable)
select avg (qtysold + 3) from sales;
select dateadd (day,30,caldate) as plus30days from date;