# abs

### Description

Returns the absolute value of an expression.

### Syntax

abs(*numeric_expression*)

### Parameters

*numeric_expression*
is a column, variable, or expression whose datatype
is an exact numeric, approximate numeric, money, or any type that
can be implicitly converted to one of these types.

### Examples

*Example 1*

Returns the absolute value of -1:

select abs(-1)

-----------
1

### 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.

For general information about mathematical functions,
see “Mathematical functions”.

### Standards

**SQL92** – Compliance level: Transact-SQL
extension.

### Permissions

Any user can execute **abs**.

### See also

**Functions** ceiling, floor, round, sign