SELECT replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(姓名,'0',''),'1',''),'2',''),'3',''),'4',''),'5',''),'6',''),'7',''),'8',''),'9','') from 表update 表 set 姓名=replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(姓名,'0',''),'1',''),'2',''),'3',''),'4',''),'5',''),'6',''),'7',''),'8',''),'9','')
while (select 1 from 表 where 姓名 like '%[0-9]%') begin update 表 set 姓名=replace(姓名,substring(姓名,patindex('%[0-9]%',姓名)-1,patindex('%[0-9]%',姓名),'') end 一个一个地替换
begin
update 表 set 姓名=replace(姓名,substring(姓名,patindex('%[0-9]%',姓名)-1,patindex('%[0-9]%',姓名),'')
end
一个一个地替换