ABS (SQL Server Compact)
Returns the absolute, positive value of the given numeric expression.
Syntax
ABS ( numeric_expression )
Arguments
- numeric_expression
Is an expression of the exact numeric or approximate numeric data type categories, or types that are implicitly convertible to float.
Return Value
Returns the same type as numeric_expression except for the following expressions:
Specified expression |
Return type |
---|---|
tinyint, smallint |
int |
real/float |
float |
Nonnumeric types that can be implicitly converted to float |
float |
Example
The following example returns the absolute value of the difference between the number of products in stock and number of products that have been ordered.
SELECT [Units In Stock] - [Units On Order] AS Expr1, ABS([Units In Stock] - [Units On Order]) AS Expr2
FROM Products
or
SELECT [Units In Stock] - [Units On Order] , ABS([Units In Stock] - [Units On Order])
FROM Products