update vs4tpostranspay set tppycardtype='CRED' WHERE tppycardtype='ARRE'
GO
update vs4tpostranspay set tppycardtype='THB' WHERE tppycardtype='BHT'
GO
update vs4tpostranspay set tppypaymenttype=(select tpymtpytalias from vs4tpayment where tpymcode=tppycardtype)where tppycardtype<>''
GO
update vs4tpostranspay set tppypaymenttype='CASH' where tppycardtype='' or tppycardtype is null or tppypaymenttype = '' or tppypaymenttype is null
GO