Re: DECODE

Les Sprott wrote:
>
> I am trying to use the following logic in a DECODE statement:
>
> if the ((abs(x/y))-1) > .02 then 'Y' elses 'N'.

  select decode( sign((abs(x/y))-1)-0.02), 1, 'Y', 'N') from sys.dual;

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841