ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

ABS function [Numeric]

Function 

Returns the absolute value of a numeric expression.

Syntax 

ABS ( numeric-expression )

Parameters 

numeric expression         The number whose absolute value is to be returned.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    SQL/foundation feature outside of core SQL.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

The following statement returns the value 66.

SELECT ABS( -66 )