create function dbo.ProcessStringTest(@str varchar(4000))
returns varchar(4000)
as
begin
declare @cnt int,@str1 varchar(1),@len int,@ret varchar(4000)
select @len=len(@str),@cnt=1,@ret=''
while @cnt<=@len
begin
select @str1=substring(@str,@cnt,1)
if @str1 in('0','1','2','3','4','5','6','7','8','9')
begin
select @ret=@ret+@str1
end
select @cnt=@cnt+1
end
return @ret
end
goselect dbo.ProcessStringTest('1a3g5e')
go
returns varchar(4000)
as
begin
declare @cnt int,@str1 varchar(1),@len int,@ret varchar(4000)
select @len=len(@str),@cnt=1,@ret=''
while @cnt<=@len
begin
select @str1=substring(@str,@cnt,1)
if @str1 in('0','1','2','3','4','5','6','7','8','9')
begin
select @ret=@ret+@str1
end
select @cnt=@cnt+1
end
return @ret
end
goselect dbo.ProcessStringTest('1a3g5e')
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货