Re: sql update

   Sheri,

   Just as an fyi, what is probably happening is your trying to update a
   customer for co 2 that doesn't have a corresponding customer in co 1( i.e.
   returns NULL value ).

   This should take care of that situation:

   update cust cus
   ----  update cust_store value with value from corresponding co 1 customer.
      set cus.cust_store = ( select substr( cust_store, 2, 6 )
                              from  cust
                             where  cust_co_no  =  1
                              and   cust_no     =  cus.cust_no )
   ---- only update customers for co 2 that have a corresponding co 1
   customer( i.e. so no nulls are returned ).
   where  cus.cust_co_no  =  2
    and   cus.cust_no in( select cust_no
                           from  cust
                          where  cust_co_no  =  1 )
   hth,
   Billy

 Unfortunately, this did not work (tried it both ways).  I received an
 error message:  Null values not allowed in column or variable CMSTOR. 

 *************************************************
 This should work:
 Update Customer a
        set Customer_Store = (select 'C'||Customer_Store from Customer
 where
 Cust#=a.Cust# and Company=1)
        where Company=