use t202324 update purchase_detail set suppbillno=replace(suppbillno,'''','') where suppbillno like '%''%'