Built-In Functions and Syntax › Invert Sign

Invert Sign

The sign inversion function reverses the sign of a numeric value. A positive numeric value becomes negative; a negative numeric value becomes positive.

Syntax:

►►─┬─ INV ─────────┬─ (value) ────────────────────────────────────────────────►◄
   ├─ INVERT ──────┤
   └─ INVERT-SIGN ─┘

Invocation names:

INV
INVERT
INVERT-SIGN

Parameters:

(value)

Specifies the numeric value whose sign is to be reversed.

Example:

This example changes 453.29 from a positive to a negative value: The value of OPER1 is 453.29.

select inv(oper1) as 'inverted-value' from table1

  INVERTED-VALUE = -453.29