create table #t1 (s varchar(20))
insert into #t1 values ('1.2.1')
insert into #t1 values ('1.2.2')
insert into #t1 values ('1')
insert into #t1 values ('1.1')
insert into #t1 values ('1.2')
insert into #t1 values ('1.3')
select
s,
REPLACE(s, '.', '')
from
#t1
order by
2
drop
table #t1