ORA-00907: Missing Right parentheses

[SkipVought]

Anyone familiar with Oracle SQL?

Does Oracle have the IIF function?

I am performing a query in MS Query from Excel to an Oracle database, getting the 00907 error. My () pairs line up. What am I doing wrong?

SELECT MFG.PART_ID, MFG.MFG_ORD, MFG.QTY, SCH.CC, SCH.OPER, SCH.LPST, DMD.DMD_ORD 

FROM FPRPTSAR.MFG_ORDER_INFO MFG, FPRPTSAR.MC_BUILD_SCHEDULE SCH, FPRPTSAR.MO_DEMAND DMD 

WHERE MFG.MFG_ORD In 

        (
          select 

          iif(
              substr(sch.traveler,1,3)='TBR'
              ,'M-'||substr(sch.traveler,4,7)
              ,substr(sch.traveler,1,7)
             ) 

          from FPRPTSAR.MC_BUILD_SCHEDULE SCH 
          where sch.cc='5AQ'
        )
 
  And (
       MFG.MFG_ORD=Substr(SCH.TRAVELER,1,7) 
       Or Substr(MFG.MFG_ORD,3,7)=Substr(SCH.TRAVELER,4,7)
      ) 
  And MFG.MFG_ORD=DMD.MFG_ORD

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[SkipVought]

I found my answer -- the IIF is not a valid function. I found the Case statement...

SELECT MFG.PART_ID, MFG.MFG_ORD, MFG.QTY, SCH.CC, SCH.OPER, SCH.LPST, DMD.DMD_ORD 

FROM FPRPTSAR.MFG_ORDER_INFO MFG, FPRPTSAR.MC_BUILD_SCHEDULE SCH, FPRPTSAR.MO_DEMAND DMD 

WHERE MFG.MFG_ORD In 

        (
         select[b] 
                case 
                  when
                     substr(sch.traveler,1,3)='TBR' 
                  then 
                     'M-'||substr(sch.traveler,4,7)
                  else 
                     substr(sch.traveler,1,7) 
                end [/b]

          from FPRPTSAR.MC_BUILD_SCHEDULE SCH 
          where sch.cc='5AQ'
        )
 
  And (
       MFG.MFG_ORD=Substr(SCH.TRAVELER,1,7) 
       Or Substr(MFG.MFG_ORD,3,7)=Substr(SCH.TRAVELER,4,7)
      ) 
  And MFG.MFG_ORD=DMD.MFG_ORD

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}