Create Function fuc(@s varchar(8000))
returns varchar(8000)
as
begin
while PATINDEX('%[吖-做]%',@s)>0
set @s=stuff(@s,PATINDEX('%[吖-做]%',@s),1,'')
return @s
end
update [tablename] set col=func(cast(col as varchar(8000))
Create Function fuc(@s varchar(8000))
returns varchar(8000)
as
begin
while PATINDEX('%[吖-做]%',@s)>0
set @s=stuff(@s,PATINDEX('%[吖-做]%',@s),1,'')
return @s
end
update [tablename] set col=func(cast(col as varchar(8000))