Is there anyway to have an IF statement?

[mber]

Hi,

"Sign" is a function which indicating the value > 0, = 0, and <0, it becomes more powerful in conjunction with "decode" function.

P.l. check "The complete reference, ORACLE 8" P418, hope it will give you a hint.

Take Care