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.

Example

The following statement returns the value 66:

SELECT ABS( -66 ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension

Sybase Compatible with Adaptive Server Enterprise