Re: sql update

["Rowe, Sheri" <srowe@xxxxxxxxx>]

Thanks Santiago,

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

I have since written a program as my Manager was getting perturbed.  It
just seemed like the perfect thing to do in SQL.  Thanks for your help
anyway.

Sheri

*************************************************
date: Thu, 15 Feb 2007 18:58:36 +0100
from: Santiago G Mart? <smarti@xxxxxxxx>
subject: Re: sql update

This should work:

Update Customer a
       set Customer_Store = (select 'C'||Customer_Store from Customer
where
Cust#=a.Cust# and Company=1)
       where Company=2

Perhaps you'd have to change it to: (select 'C'||substr(Customer_Store,
1,
n) from ...
where n is the length of field Customer_Store.


Saludos,
                  ---------------------------
                    Santiago Mart?
                       Dusen, S.A.
                  ---------------------------