use t202324




DELETE FROM OPENING_PURCHASE_IMAGES_DETAIL 
DELETE FROM OPENING_PURCHASE_ITEM_DETAIL 
DELETE FROM OPENING_PURCHASE_ADDLESS_DETAIL 
DELETE FROM OPENING_PURCHASE_TRANSPORT_DETAIL 
DELETE FROM OPENING_PURCHASE_DETAIL 

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'