UPDATE VS4TChequerec Set TCHRPayChqDate=(SELECT TRVHDate FROM VS4TARVoucher WHERE VS4TARVoucher.TRVHNO=VS4TChequerec.TCHRTRVRTRVHNo)
WHERE TCHRTRVRTRVHNo = '' or TCHRTRVRTRVHNo is NULL or TCHRTRVRTRVHNo='3333-3-3'
GO
UPDATE VS4TChequerec Set TCHRPayChqDate=TCHRChqDate WHERE TCHRPayChqDate is not NULL
GO
