Returns the sign of a number.
SIGN( numeric-expression )
numeric-expression The number for which the sign is to be returned.
SMALL INT
For negative numbers, the SIGN function returns -1.
For zero, the SIGN function returns 0.
For positive numbers, the SIGN function returns 1.
SQL/2003 Vendor extension.
The following statement returns the value -1
SELECT SIGN( -550 ); |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |