abs

Returns the absolute value of an expression.

Syntax

abs(numeric_expression)

Parameters

Examples

Usage

abs, a mathematical function, returns the absolute value of a given expression. Results are of the same type and have the same precision and scale as the numeric expression.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute abs.

Related reference
ceiling
floor
round
sign