TOTALORDER

The TOTALORDER function returns an ordering for DECFLOAT values. The TOTALORDER function returns a small integer value that indicates how expression1 compares with expression2.

Syntax

TOTALORDER(decfloat, decfloat)

Example

select TOTALORDER(DECFLOAT(-1.1), DECFLOAT(-1.2))