create function fnTest(@name nvarchar(50))
returns nvarchar(50)
as
begin
while PATINDEX('%[吖-座]%',@name) > 0
set @name = stuff(@name,PATINDEX('%[吖-座]%',@name),1,N'')
return @name
end
GO
returns nvarchar(50)
as
begin
while PATINDEX('%[吖-座]%',@name) > 0
set @name = stuff(@name,PATINDEX('%[吖-座]%',@name),1,N'')
return @name
end
GO