Progress
SQL-92
Guide and Reference


SIGN Function

Returns 1 if expression is positive, -1 if expression is negative, or zero if expression is zero.

SYNTAX

SIGN ( expression ) 

EXAMPLE

This example illustrates the SIGN function:

SELECT SIGN(-14) ’Sign’ FROM SYSPROGRESS.SYSCALCTABLE; 

NOTE

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095