update vs4tinventorymb set tinmlotno='AUTO' WHERE tinmlotno is null
GO
update vs4tinventorymb set tinmlotno='AUTO' WHERE tinmlotno=''
GO
update vs4tinventoryMB set tinmlotDate='3333-3-3' where tinmlotdate is null
GO
update vs4tinventoryMB set tinmtpdtcode='' where tinmtpdtcode is null
GO
update vs4tinventoryMB set tinmcustom1='' where tinmcustom1 is null
GO
update vs4tinventoryMB set tinmserialno='' where tinmserialno is null
GO