0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

declare @strTest VARCHAR(15);
declare @i as int;
declare @outStr as varchar(max);
select @strTest = '00098AB$709.89';
set @i = 0;
set @outStr = '';

while @i <= len(@strTest)
begin
    declare @a as varchar(1);
    select @a = substring(@strTest, @i, 1);
    if  @a like '[0-9]'
     set @outStr += @a;
    set @i += 1;
end

select @outStr;

fork query

edited aug 15 23

created aug 15 23 ullas