ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the sign of a number.
SIGN ( numeric-expression )
numeric-expression The number for which the sign is to be returned.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise.
The following statement returns the value -1
SELECT SIGN( -550 )
For negative numbers, SIGN returns -1.
For zero, SIGN returns 0.
For positive numbers, SIGN returns 1.