Removing alphabetic characters in SQL Server

I need to change

ABC2001  
ABCD2001 
ASDF111111

to

2001
2001
111111

I need to remove alphabetic characters in SQL Server, any idea?

+3
source share
1 answer

Below is the function below

create function NoLetters(@string2number varchar(200)) 
 returns varchar(200)
as
begin
  declare @c int
  declare @num varchar(200)
  set @num = ''
  declare @txtCurrent char(1)
  set @c=1
  while @c<=len(@string2number)
    begin
     set @txtCurrent = substring(@string2number,@c,1)
     if ascii(@txtCurrent) between 48 and 57
       set @num = @num + @txtCurrent
     set @c=@c+1
   end
 return @num
end
0
source

All Articles