From: gagarp@gmail.com   
      
   In control File I need to include one more when condition that checks if last   
   two digit of NUMBER is in range 00 to 19 like:   
   "substr(NUMBER,-2,2) in (00,01,02,03,04,05,06,07,08,09,10,11,12,   
   3,14,15,16,17,18,19)"   
      
      
   control file looks like:   
   append   
   into table    
   when   
   TRANSACTION_TYPE = 'XXX'   
   and USE != '0' and   
   substr(NUMBER,-2,2) in (00,01,02,03,04,05,06,07,08,09,10,11,12,1   
   ,14,15,16,17,18,19)   
      
      
   getting error:   
   SQL*Loader-350: Syntax error at line 9.   
   Expecting = or "<>", found "(".   
   substr(NUMBER,-2,2) in (00,01,02,03,04,05,06,07,08,09,10,11   
   ^   
      
   please suggest how to use the multiple options in when condition.   
   Thanks   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)