USE T202223

delete from dbo.RECEIVED_PAYMENT_DETAIL where len(recsrno)=10 and left(right(recsrno,5),1) = '9'
delete from dbo.RECEIVED_ADDLESS_DETAIL where len(recsrno)=10 and left(right(recsrno,5),1) = '9'
delete from dbo.RECEIVED_IMAGES_DETAIL where len(recsrno)=10 and left(right(recsrno,5),1) = '9'
delete from dbo.RECEIVED_DETAIL where len(recsrno)=10 and left(right(recsrno,5),1) = '9'



delete from dbo.RETURN_GOODS_ITEM_DETAIL where len(rtnsrno)=10 and left(right(rtnsrno,5),1) = '9'
delete from dbo.RETURN_GOODS_ADDLESS_DETAIL where len(rtnsrno)=10 and left(right(rtnsrno,5),1) = '9'
delete from dbo.RETURN_GOODS_IMAGES_DETAIL where len(rtnsrno)=10 and left(right(rtnsrno,5),1) = '9'
delete from dbo.RETURN_GOODS_DETAIL where len(rtnsrno)=10 and left(right(rtnsrno,5),1) = '9'



select * from received_detail where len(recsrno)=10 and recsrno='1516000258'
select * from received_detail where len(recsrno)=10 and recsrno='1516060258'
select * from received_detail where len(recsrno)=10 and left(right(recsrno,5),1) = '9'