create function dbo.StripLetters ( @value varchar(10) ) returns int as begin declare @letter char(1) set @letter = 'A' while (@letter <> 'Z') begin set @value = replace(@value, @letter, '') set @letter = char(ascii(@letter) + 1) end return convert(int, @value) end go create table oMain (Number char(10)) insert into oMain values ('1058') insert into oMain values ('1058A') insert into oMain values ('1167') insert into oMain values ('2054B') insert into oMain values ('3001') insert into oMain values ('3000A') insert into oMain values ('22A') select * from oMain where case isnumeric(number) when 1 then convert(int, number) else dbo.StripLetters(number) end between 1100 and 3000 select * from oMain where dbo.StripLetters(number) between 1100 and 3000 drop table oMain drop function dbo.StripLettersHTH,