Re: DECODE
From: janet <janet_at_telesph.com>
Date: 1996/12/04
Message-ID: <32A5AF13.6528_at_telesph.com>#1/1
Date: 1996/12/04
Message-ID: <32A5AF13.6528_at_telesph.com>#1/1
Try:
decode(sign(abs(x/y) - 1.02), 1, 'Y', 'N')
janet
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'.
>
> any help would be greatly appreciated.
>
> Les Sprott
> Transco Energy
Received on Wed Dec 04 1996 - 00:00:00 CET