Re: DECODE
From: Manh-Hoa Le <at770_at_FreeNet.Carleton.CA>
Date: 1996/12/04
Message-ID: <584gaf$khp_at_freenet-news.carleton.ca>#1/1
Date: 1996/12/04
Message-ID: <584gaf$khp_at_freenet-news.carleton.ca>#1/1
Les Sprott (les.e.sprott_at_tgpl.twc.com) writes:
> I am trying to use the following logic in a DECODE statement:
>
> if the ((abs(x/y))-1) > .02 then 'Y' elses 'N'.
DECODE (SIGN(ABS(x/y) - 1.02), 1, 'Y', 'N')
>
> any help would be greatly appreciated.
>
> Les Sprott
> Transco Energy
Received on Wed Dec 04 1996 - 00:00:00 CET