Re: DECODE? IIF?

Cathy Morse <Cathy.Morse_at_ClemsonSC.ATTGIS.COM> wrote:
>I'm trying to pull data from 2 different fields, depending on
>the result of a comparison.
>
>
>I need to compare the DATE field to SYSDATE and pull either
>PLAN or ACTUAL.
>
>How do I do this?

The decode statements should handle this, but for the life of me, I can't make it (I've tried for the last 5 minutes, but don't have my SQ Lang. Guide handy)

From the looks of your data, isn't a nvl(actual,planned) just as good?

>
>Thanks

HTH Alan

Alan Johnson                            MIS Director
email: alan.johnson_at_gel.com             General Engineering Labs
v: (803) 556-8171 f: (803) 766-1178     2040 Savage Road, Charleston,SC 29414