UPDATE VS4TInventoryLOT Set TIMCProposeStatus=0 WHERE TIMCProposeStatus is null
GO
UPDATE VS4TInventoryLOT Set TIMCProposeNote='' WHERE TIMCProposeNote is null
GO
UPDATE VS4TInventoryLOTP Set TIMCProposeStatus=0 WHERE TIMCProposeStatus is null
GO
UPDATE VS4TInventoryLOTP Set TIMCProposeNote='' WHERE TIMCProposeNote is null
GO
UPDATE VS4TInventoryLOT Set TIMCCOA=0 WHERE TIMCCOA is null
GO
UPDATE VS4TInventoryLOTP Set TIMCCOA=0 WHERE TIMCCOA is null
GO
UPDATE VS4TInventoryMB Set TInMTPltCode='-' WHERE TInMTPltCode is null or TInMTPltCode=''
GO
UPDATE VS4TInventoryMBP Set TInMTPltCode='-' WHERE TInMTPltCode is null or TInMTPltCode=''
GO
UPDATE VS4TInventoryMB Set TInMFromTPltCode='-' WHERE TInMFromTPltCode is null or TInMFromTPltCode=''
GO
UPDATE VS4TInventoryMBP Set TInMFromTPltCode='-' WHERE TInMFromTPltCode is null or TInMFromTPltCode=''
GO