create table #t(id int)
insert #t select 50
union all select 120
union all select 190
union all select 1020
union all select 1890
union all select 10120select case when (id/100)*100=id then id else (id/100+1)*100 end from #tdrop table #t
/*
-----------
100
200
200
1100
1900
10200(6 row(s) affected)
*/
insert #t select 50
union all select 120
union all select 190
union all select 1020
union all select 1890
union all select 10120select case when (id/100)*100=id then id else (id/100+1)*100 end from #tdrop table #t
/*
-----------
100
200
200
1100
1900
10200(6 row(s) affected)
*/
FROM one_table