decode(PSEG.PSCDE,'PLAN',decode(PSPLN.PLNFLAG, 'Y',1,0),0)
"Cynic" <ksd9_at_yahoo.com> wrote in message
news:ullk8hchb20k9d_at_corp.supernews.com...
> I think DECODE is what I'm looking for, but I can't seem to figure out how
> it works.
>
> Here's what I have... I have a field called P_BILL.
> If PSEG.PSCDE = 'PLAN' and PSPLN.PLNFLAG = 'Y', then I need the P_BILL
> field to be 1. Otherwise, 0.
>
> Any suggestions?? Or any good references for DECODE??
>
> Thanks
>
>
>
>
>
Received on Wed Aug 14 2002 - 19:40:17 CDT
