This sample uses higher than, less than, ISNumeric, and expresions with Varchar fields.
Declare @esn Table(id int primary key,Num varchar(11))
insert into @esn
values (1,'123456AB'),
(2,'123ABC65'),
(3,'12563254'),
(4,'15647894'),
(5,'15698736'),
(6,'8564589A'),
(7,'ABC25632'),
(8,'C1111111'),
(9,'ADFGETHQ'),
(10,'0SARGENTO1'),
(11,'M67AB8340Z')
/*Query only Numeric*/
Select *
from @esn
where ISNUMERIC(Num)=1
/*Query Start with a Letter*/
Select *
from @esn
where Num > 'A'
/*End with a letter*/
Select...
Read more