UPDATE VS4TTaxTrans Set TTxTBranchCode='00000' WHERE TTxTBranchName='สำนักงานใหญ่'
GO
UPDATE VS4TTaxTrans Set TTxTBranchCode=(SUBSTRING('00000',1,5-len(TTxTBranchCode))+TTxTBranchCode) WHERE len(TTxTBranchCode) < 5
GO