Re: calc field

You nested NVL functions, or DECODES, or we didn't even show you 9i's new CASE statement.......

Cheers,
Brian

Roger Smith wrote:
>
> IF both are null, can I set a default?
>
> "Michel Cadot" <micadot2removethat_at_free.fr> wrote in message
> news:3f79e71d$0$10410$626a54ce_at_news.free.fr...
> >
> > "Roger Smith" <rsmith22_at_fastmail.net> a écrit dans le message de
> > news:4ileb.35770$H86.839814_at_news1.telusplanet.net...
> > > Need suggestions on how to accomplish this, I know you can create a
> > > calculated field in sql:
> > >
> > > select (productPrice * 1.5) as "NewPrice"
> > >
> > > but my calc field is complicated by if then, if productPrice not null
> then
> > >
> > > select (productPrice * 1.5) as "NewPrice" else
> > >
> > > select (WarehousePrice * 1.5) as "NewPrice"
> > >
> > > and so on... can this be done in sql?
> > >
> > > Roger
> > >
> > >
> >
> > Use the NVL function:
> > select nvl(productPrice,WarehousePrice)*1.5 as "NewPrice" ...
> >
> > Hope this helps
> > Michel Cadot
> >
> >

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"