一個二十分的題

Question

insert table2(oldAsset)
select replace(replace(oldAsset,'+',''),'@','') as oldAsset
from table1

Answer 1

位数固定的话，就用right(oldAsset,13)

Answer 2

insert table2(oldAsset)
select replace(replace(replace(replace(oldAsset,'+',''),'@',''),'-',''),'"','') as oldAsset
from table1

Answer 3

位数不固定呀。还有
++C2001A4AF0048_1