use t202324


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'

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'