create function f_replace(@str varchar(8000))
returns varchar(8000)
as
begin
while patindex('%[^a-zA-Z^0-9^ ^'']%',@str)>0
begin
set @str=stuff(@str,patindex('%[^a-zA-Z^0-9^ ^'']%',@str),1,'')
end
create function f_replace(@str varchar(8000))
returns varchar(8000)
as
begin
while patindex('%[^a-zA-Z^0-9^ ^'']%',@str)>0
begin
set @str=stuff(@str,patindex('%[^a-zA-Z^0-9^ ^'']%',@str),1,'')
end