HOW to translate this logic into DECODE

From: April <privatebenjamin_at_hushmail.com>
Date: 5 Jul 2002 14:47:51 -0700
Message-ID: <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 Received on Fri Jul 05 2002 - 23:47:51 CEST

This message: [ Message body ]
Next message: Uday Joshi: "Problem with Oracle 8i client & Oracle forms 6i"
Previous message: Mark Townsend: "Re: Security - keeping data separate"
Next in thread: April: "Re: HOW to translate this logic into DECODE"
Reply: Rauf Sarwar: "Re: HOW to translate this logic into DECODE"
Reply: April: "Re: HOW to translate this logic into DECODE"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message