Hi Mega,
Please check out this query...i think it will work
drop table #temp
create table #temp
(
surveyno int,
subdivno varchar(10)
)
INSERT INTO #temp values(1, '1')
INSERT INTO #temp values(3, '3B')
INSERT INTO #temp values(2, '2')
INSERT INTO #temp values(3, '3')
INSERT INTO #temp values(2, '2B')
INSERT INTO #temp values(3, '3A')
INSERT INTO #temp values(2, '2A')
INSERT INTO #temp values(1, '1A')
select *, convert(int,convert(varchar(10),left(subdivno,len(subdivno)-1)) + convert(varchar(10),ascii(right(subdivno,1)))) as 'test'
from #temp
order by surveyno, test
Subu.