Re: DECODE or else, a little test...

lesliet_at_u.washington.edu (L. Tseng) wrote:
>
>Can DECODE do the following?
>
> IF colA > 100 THEN 'A'
> ELSIF colA = 100 THEN 'B'
> ELSE 'C'
>
Sure :

decode (sign (colA-100),1,'A',0,'B','C')

Gernot Received on Wed Nov 13 1996 - 00:00:00 CET