From: gagarp@gmail.com   
      
   Found this useful:   
   https://stackoverflow.com/questions/46095847/sqlloader-how-to-us   
   -substr-in-when-clause-correctly   
      
   Solution:   
   Use position  in when condition as:   
      
   append   
   into table    
   when   
   TRANSACTION_TYPE = 'XXX'   
   and USE != '0'   
   and (13:14) = '00'   
      
   Thanks   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)