Hi
Bandi
I need ascending order data following requirements
create table #temp1(Name varchar(20))
insert into #temp1 (Name)
select 'ZenCar1523'
union all
select 'Apple0-300'
union all
select 'Fox110-150'
union all
select 'Hen61-230'
union all
select 'Yamaha41-71'
union all
select 'Rx81-100'
Select * from #temp1
--I need output this
--=====================
Apple0-300
Fox110-150
Hen61-230
Rx81-100
Yamaha41-71
ZenCar1523
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com