Scalar Functions

The following scalar functions are supported in expressions. They work exactly like the SQL functions with the same name (and in fact call the corresponding SQL function).

Mathematical Functions

Function	Function	Function	Function
abs	acos	asin	atan
atn2	ceiling	cos	cot
degrees	exp	floor	log
log10	pi	power	radians
rand	round	sign	sin
sqrt	square	tan

String Functions

Function	Function	Function	Function
ascii	char	charindex	concat
concat_ws	difference	format	left
len	lower	ltrim	nchar
patindex	quotename	replace	replicate
reverse	right	rtrim	soundex
space	str	string_escape	stuff
substring	translate	trim	unicode
unistr	upper

Conditional Functions

Function	Function	Function	Function
choose	coalesce	iif	isnull
isnumeric	nullif	greatest	least

Bitwise Functions

Function	Function	Function	Function
bit_count	get_bit	left_shift	right_shift
set_bit

Date Functions

Function	Function	Function
datefromparts	day	month
year

Other Functions

Function
newid