Re: DECODE
From: Geoff Ingram <lsgvi02_at_chsrh1.agw.bt.co.uk>
Date: 1996/12/04
Message-ID: <32A5B554.2D_at_chsrh1.agw.bt.co.uk>#1/1
Date: 1996/12/04
Message-ID: <32A5B554.2D_at_chsrh1.agw.bt.co.uk>#1/1
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'.
>
try
decode(sign((abs(x/y))-1-0.2),-1,'N',0,'N','Y')
regards Geoff Ingram
All my own personal opinions Received on Wed Dec 04 1996 - 00:00:00 CET