Re: DECODE or else, a little test...
From: John Blackburn <jb2_at_qdot.qld.gov.au>
Date: 1996/11/14
Message-ID: <Pine.GSO.3.93.961114111610.14545A-100000_at_avalon>#1/1
Date: 1996/11/14
Message-ID: <Pine.GSO.3.93.961114111610.14545A-100000_at_avalon>#1/1
On 13 Nov 1996, L. Tseng wrote:
> Can DECODE do the following?
>
> IF colA > 100 THEN 'A'
> ELSIF colA = 100 THEN 'B'
> ELSE 'C'
DECODE(least(colA,100),100,DECODE(colA,100,'B','A'),'C')
(I tested this and it works.)
John Blackburn jb2_at_qdot.qld.gov.au Queensland Transport +61 7 32534634Australia
#include <std_disclamers.h>
#include <nonstd_disclamers.h>
Received on Thu Nov 14 1996 - 00:00:00 CET