create function jk(
@var varchar(500)
)returns varchar(500)
as
begin
declare @a varchar(500)
set @a=''
while(len(@var)>0)
begin
if left(@var,1)>='0' and left(@var,1)<='9'
set @a=@a+left(@var,1)
set @var=stuff(@var,1,1,'')
end
return @a
end
declare @var varchar(500),@a varchar(500),@i int
select @var='KL133+230',@a='',@i=len(@var)
while(len(@var)>0)
begin
if left(@var,1)>='0' and left(@var,1)<='9'
begin
set @a=@a+left(@var,1)
end
--创建自定义函数
create function fn_getnum(@str nvarchar(4000))
returns nvarchar(4000)
as
begin
declare @i int
declare @strret nvarchar(4000)
set @i = 0
set @strret = ''
while @i <= len(@str)
begin
if substring(@str,@i,1) in ('0','1','2','3','4','5','6','7','8','9')
set @strret=@strret + substring(@str,@i,1)
set @i = @i + 1
end