Navigation:  »No topics above this level«

SIGN()

Advantage Concepts

Return to chapter overview

Scalar function that returns an indicator of the sign of the parameter.

Supported in SQL:

Yes

Supported in Navigational:

Yes

Syntax

SIGN( <nValue> ) à nSign

Parameters

<nValue>

Value to test

Return Value

-1, 0, or 1

Remarks

If <nValue> is less than zero, -1 is returned. If <nValue> equals zero, 0 is returned. If <nValue> is greater than zero, 1 is returned.

See Also

Math Functions