--------以下包括小数点-----------
declare @String varchar(1000),@TempNum char(1),@Number varchar(1000)
select @String='ab1.2我c'
select @Number=''
while len(@String)>0
begin
select @TempNum=substring(@String,1,1)
if isnumeric(@TempNum)=1
begin
select @Number=@Number+@TempNum
end
select @String=stuff(@String,1,1,'')
end
select @Number
-------以下去小数点也去掉----------
declare @String varchar(1000),@TempNum char(1),@Number varchar(100)
select @String='12321312.wqr4swd77878'
select @Number=''
while len(@String)>0
begin
select @TempNum=substring(@String,1,1)
if ascii(@TempNum)>=48 and ascii(@TempNum)<=57
begin
select @Number=@Number+@TempNum
end
select @String=stuff(@String,1,1,'')
end
select @Number
----------