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

Hi,

is there a way to use an 'IF..THEN..ELSE' construction in SQL. I am using Oracle8.

something like this should be done:

select ID as custID, IIF( ordervol > 1000 ; 'fine' ; 'bad' ) as foo from customer

the only thing i found in the docs is the DECODE statement. But there is no way to use rangeexpression....

thanx for any advice,

markus.pfadenhauer_at_studtum.lrz-muenchen.de Received on Wed Mar 22 2000 - 14:38:57 CST