Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

SHORT_PLAN function [Miscellaneous] Next Page

SIGN function [Numeric]

Returns the sign of a number.


SIGN( numeric-expression )


numeric-expression    The number for which the sign is to be returned.


For negative numbers, the SIGN function returns -1.

For zero, the SIGN function returns 0.

For positive numbers, the SIGN function returns 1.

Standards and compatibility

The following statement returns the value -1

SELECT SIGN( -550 );