select  max(to_number(goods)) from (select case when regexp_like(replace(goods_no,‘A05‘,‘‘),‘[A-Za-z]‘) then ‘0‘ else replace(goods_no,‘A05‘,‘‘) end  goods,goods_nofrom tb_b_goods where goods_no like ‘A05%‘ ) aawhere goods!=0 ;