update mig_pledgegold set grosswt = grosswt + 0.001 where RIGHT(GROSSWT,1) = 9
update mig_pledgegold set netwt = netwt + 0.001 where RIGHT(netwt,1) = 9
update pledgegold set GrossWt = mig_pledgegold.GrossWt,
NetWt = mig_pledgegold.NetWt from mig_pledgegold inner join pledgegold
on mig_pledgegold.acmastid = pledgegold.acmastid