Funtion to Seperate Numbers From Charaters

Create Function [dbo].[NoLetters] (@number varchar(20))

Returns varchar(20) 

as 

begin 

 declare @c int 

 set @c=65 

 while @c<65+26 

 begin 

 set @number=replace(@number,char(@c),'') 

 set @c=@c+1 

 end 

return(@number) 

end 

 

----------------------------- 

Input 'MA1234'

Output '1234'

-----------------------------