Funtion to get Number Part of the Alphanumeric String

create function 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