Progress
SQL-92
Guide and Reference


ABS Function

Computes the absolute value of expression.

SYNTAX

ABS ( expression ) 

EXAMPLE

This example illustrates the ABS function:

SELECT ABS (MONTHS_BETWEEN (SYSDATE, order_date)) 
    FROM orders
    WHERE  ABS (MONTHS_BETWEEN (SYSDATE, order_date)) > 3 ; 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095