Pbm with display of recors

[shan_cool]

Hi all,

I need to dispaly a set of records in ascending order..

 

I hav given the query as:

Select * From Emp_Det where Emp_Id like '$Emp_Id%' and Emp_Status <> 'R' order by Emp_Id ASC

 

It displays:

EmployeeId Name

1 Ranga

10 Sajan C K

101 Sridevi

112 Niraj

198 Florence Lavanya

199 M.Subbarao

2 N N Subramanian

20 Rosario

 

but i neeed to display it as:

EmployeeId Name

1 Ranga

2 N N Subramanian

10 Sajan C K

20 Rosario

101 Sridevi

112 Niraj

198 Florence Lavanya

199 M.Subbarao

 

plz help me out to change it....

shan,

chennai,

India..........