Re: Help needed for an IF ..THEN...ELSE Construction

From: R.A.G. <d0naldd_at_hotmail.com>
Date: Thu, 23 Mar 2000 13:29:09 +0100
Message-ID: <953814767.845522@newsreader1.wirehub.nl>

>
> something like this should be done:
>
> select ID as custID, IIF( ordervol > 1000 ; 'fine' ; 'bad' ) as foo
> from customer

something like this ?

select id as custid
, decode(sign(ordervol,-1000),-1,'bad','fine') from customer;

or

select id

,       decode(FLOOR(ordervol/1000)),0,'not enough stock'
                                                           ,1,'at least
1000'
                                                           ,2,'at least
2000'
                                                           ,'more than

enough')
from customer;

Rob Received on Thu Mar 23 2000 - 06:29:09 CST