UPDATE VS4TInventoryMB set tinmshow=1 where tinmshow is null
GO
UPDATE VS4TInventoryMB set tinmArrear=tinmquantitycalc where tinmArrear is null
GO
UPDATE VS4TInventoryCost set timccustom4='' where timccustom4 is null
GO
UPDATE VS4TInventoryCost set timccustom5='' where timccustom5 is null
GO
UPDATE VS4TInventoryCost set timcJobCode='' where timcJobCode is null
GO
UPDATE VS4TInventoryCost set timcserialno='' where timcserialno is null
GO
