Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SIGN

> Returns `1` if `expression` is positive, `-1` if expression is negative, or zero if `expression` is zero.

> #### Syntax

>     SIGN ( expression )

> Example

> This example illustrates the `SIGN` function:

>     SELECT SIGN(-14) 'Sign' FROM MYMATH;

> #### Note

> - `expression` must evaluate to a `NUMERIC` data type.

> ##### Compatibility

> ODBC compatible

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