ABS
A mathematical function that returns the absolute (positive) value of the specified numeric expression. ABS changes negative values to positive values. ABS has no effect on zero or positive values.
Syntax
ABS ( numeric_expression )
Arguments
numeric_expression
Is an expression of the exact numeric or approximate numeric data type category.
Return types
Returns the same type as numeric_expression, excluding types described below:
| input type | output type |
|---|---|
| smallmoney | money |
| bit | float |
| real | float |
| smallint | int |
| tinyint | int |
Example
SELECT ABS(1.01e0);