UPDATE VS4TChequeRec Set TCHRPayTo=(SELECT TARNName From VS4TAR Where VS4TChequeRec.TCHRTARNCODE=VS4TAR.TARNCode) WHERE TCHRPayTo='' or TCHRPayTo is null
GO
UPDATE VS4TChequeRec Set TCHRType=0 WHERE TCHRType is null
GO
UPDATE VS4TChequeSub Set TCHSType=0 WHERE TCHSType is null
GO