78a833e8   
   From: Plamen@SQLStudio.com   
      
   Not sure what you need, but try this (make sure to try on test data not   
   directly on production):   
      
   UPDATE Tables   
   SET salesman = 30   
   WHERE salesman = 25   
      AND customer IN ('Jeff', 'Kory', 'Jean');   
      
   If you need to update all customers, then this:   
      
   UPDATE Tables   
   SET salesman = 30   
   WHERE salesman = 25;   
      
   --   
   Plamen Ratchev   
   http://www.SQLStudio.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)