Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## ABS

> 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

> - The argument to the function must be of type `TINYINT`, `SMALLINT`, `INTEGER`, `NUMERIC`, `REAL`, or `FLOAT`.

> - The result is of type `NUMERIC`.

> - If the argument `expression` evaluates to `NULL`, the result is `NULL`.

> ##### Compatibility

> ODBC compatible

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