drop table #Tmp 
go
create table #Tmp (col numeric( 9 ))

insert into #Tmp values( 123456780 )
insert into #Tmp values( 123456781 )
insert into #Tmp values( 123456782 )
insert into #Tmp values( 123456783 )
insert into #Tmp values( 123456784 )
insert into #Tmp values( 123456785 )
insert into #Tmp values( 123456786 )
insert into #Tmp values( 123456787 )
insert into #Tmp values( 123456788 )
insert into #Tmp values( 123456789 )
select  1  from #Tmp
Group by left(col, 8 )+case when right(col, 1 )< 5  then  0  else  1  end