shan_cool Posted December 5, 2005 Share Posted December 5, 2005 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.......... Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted December 5, 2005 Share Posted December 5, 2005 so Emp_Id is varchar? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.