Neoview SQL Reference Manual (R2.2)

SIGN Function
The SIGN function returns an indicator of the sign of a numeric value expression. If the value is
less than zero, the function returns -1 as the indicator. If the value is zero, the function returns
0. If the value is greater than zero, the function returns 1.
SIGN is a Neoview SQL extension.
SIGN (numeric-expression)
numeric-expression
is an SQL numeric value expression that specifies the value for the argument of the SIGN
function. See “Numeric Value Expressions” (page 217).
Examples of SIGN
• Return the value –1:
SIGN (-20 + 12)
• Return the value 0:
SIGN (-20 + 20)
• Return the value 1:
SIGN (-20 + 22)
404 SQL Functions and Expressions