Re: HOW to translate this logic into DECODE

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 Mon Jul 08 2002 - 21:17:51 CEST