UPDATE VS4TBranch Set TBraNameOnForm=TBraName WHERE TBraNameOnForm='' or TBraNameOnForm is null
GO
UPDATE VS4TBranch Set TBraAddressBill2=TBraAddressBill WHERE TBraAddressBill2='' or TBraAddressBill2 is null
GO
UPDATE VS4TBranch Set TBraAddressBillOF=TBraAddressBill WHERE TBraAddressBillOF='' or TBraAddressBillOF is null
GO