declare @myTable table(a varchar(10)) insert into @myTable select '#1' union all select '#2' union all select '#3' union all select '#4' union all select '#5' union all select '#6' union all select '#7' union all select '#9' union all select '#10' union all select '#11' select * from @myTable order by convert(int,substring(a,2,len(a)))
insert into @myTable
select '#1' union all
select '#2' union all
select '#3' union all
select '#4' union all
select '#5' union all
select '#6' union all
select '#7' union all
select '#9' union all
select '#10' union all
select '#11' select * from @myTable order by convert(int,substring(a,2,len(a)))