SQL函数 ： 查找字段中不符合要求的记录

create function dbo._NoNeed(@str varchar(4000))
returns varchar(4000)
as
begin
 declare @re int,@i int,@lo varchar(4000),@ll varchar(4000)
        set @i=len(@str)
        set @re=0
 set @str=lower(rtrim(@str))
 while @i>=@re
 begin
        set @lo =left(@str,1)
        if(@lo not like '[1,2,3,4,5,6,7,8,9,0,.]' or @lo like ',')
        begin
        set @ll=@str
        end
 set @str=right(@str,@i-1)
        set @re=@re+1
        set @i=len(@str)
 end
 return @ll    
end
go
select aaa,dbo._NoNeed(aaa) from table1

go
drop function dbo._NoNeed