UPDATE VS4TARInvoice Set TIvoBranchCode='00000' WHERE TIvoBranchCode='' or TIvoBranchCode is null or TIvoBranchCode='0000'
GO
UPDATE VS4TARInvoice Set TIvoBranchName='สำนักงานใหญ่' WHERE TIvoBranchName='' or TIvoBranchName is null
GO
UPDATE VS4TAPInvoice Set TIAPBranchCode='00000' WHERE TIAPBranchCode='' or TIAPBranchCode is null or TIAPBranchCode='0000'
GO
UPDATE VS4TAPInvoice Set TIAPBranchName='สำนักงานใหญ่' WHERE TIAPBranchName='' or TIAPBranchName is null
GO