Hi..
See the below code...
it will return you all isnumeric value in single variable and not isnumeric value in another variable..
declare @str varchar(100)
declare @cnt int
declare @letter int
declare @nstr varchar(100)
declare @vstr varchar(100)
set @vstr=''
set @nstr=''
set @str ='dsfdsf43543543sfas34534asf4354 Rajnish375747893897389538475'
set @cnt = 1
while @cnt < len(@str)
begin
select @letter = isnumeric(substring(@str,@cnt,1))
if @letter = 1
begin
set @nstr=@nstr+substring(@str,@cnt,1)
end
else
begin
set @vstr=@vstr+substring(@str,@cnt,1)
end
set @cnt=@cnt+ 1
end
print @nstr
print @vstr