Try OpenEdge Now
SQL Reference
SQL Reference
:
OpenEdge SQL Functions
:
SIGN
SIGN
Returns
1
if
expression
is positive,
-1
if
expression
is negative, or zero if
expression
is zero.
Syntax
SIGN (
expression
)
Notes
expression
must evaluate to a
NUMERIC
data type.
Example
This example illustrates the
SIGN
function:
SELECT SIGN(-14) 'Sign' FROM MYMATH;
Compatibility
ODBC compatible
