Re: HOW to translate this logic into DECODE

Thanks very much,

that's considerably simpler than what I wa attempting to do!

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0207081117.3382df70_at_posting.google.com>...
> privatebenjamin_at_hushmail.com (April) wrote in message news:<21e9f79.0207051347.346a811_at_posting.google.com>...
> > I have this statement below from an Access97 database query.
> >
> > "IIf((([Status_Code]>0 And [Status_Code]<5) Or
> > [Release_Indicator]=False)
> > And [RP_Indicator]=True,True,False)"
> >
> > How can I convert this into the Oracle DECODE format?
> >
> > Each field in the query is a number field consisting of either -1,
> > (true) or 0 (false).
> >
> > Thanks for your help,
> > April
>
>
>
> WHERE ((status_code BETWEEN 0 and 5) OR (release_indicator = 0))
> AND rp_indicator = DECODE(rp_indicator, 1, 1, 0)
>
> HTH
> //Rauf Sarwar
Received on Tue Jul 09 2002 - 19:33:14 CEST