USE T201920

UPDATE RETURN_GOODS_DETAIL  SET RtnSrNo=RIGHT('000'+CONVERT(VARCHAR(255),CONVERT(nUMERIC(6),RtnSrNo)-9651),6) WHERE LEN(RTNSRNO)=6 AND RTNSRNO>='009795'
UPDATE RETURN_GOODS_ADDLESS_DETAIL  SET RtnSrNo=RIGHT('000'+CONVERT(VARCHAR(255),CONVERT(nUMERIC(6),RtnSrNo)-9651),6) WHERE LEN(RTNSRNO)=6 AND RTNSRNO>='009795'
UPDATE RETURN_GOODS_ITEM_DETAIL  SET RtnSrNo=RIGHT('000'+CONVERT(VARCHAR(255),CONVERT(nUMERIC(6),RtnSrNo)-9651),6) WHERE LEN(RTNSRNO)=6 AND RTNSRNO>='009795'
UPDATE RETURN_GOODS_IMAGES_DETAIL  SET RtnSrNo=RIGHT('000'+CONVERT(VARCHAR(255),CONVERT(nUMERIC(6),RtnSrNo)-9651),6) WHERE LEN(RTNSRNO)=6 AND RTNSRNO>='009795'

UPDATE RETURN_GOODS_DETAIL  SET rtnfirmsrno= rtnsrno