select * from tb where left(right(ltrim(col),2),1)='1'
select * from tb where col like '%1_'
select * from tb where right(cast(co1 as varchar),2) like '1%' and col > 9
create table #(Col INT) insert into # values(10) insert into # values(12) insert into # values(514) insert into # values(8109) insert into # values(45424545) goselect * from # WHERE (col%100)/10=1 Go DROP TABLE # Col ----------- 10 12 514
from tb
where left(right(ltrim(col),2),1)='1'
from tb
where col like '%1_'
insert into # values(10)
insert into # values(12)
insert into # values(514)
insert into # values(8109)
insert into # values(45424545)
goselect *
from #
WHERE (col%100)/10=1
Go
DROP TABLE #
Col
-----------
10
12
514