去除汉字

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