Order By clause in query
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   raj_ranjan
Posted On:   Wednesday, April 10, 2002 08:04 AM

Is there a way by which the number field can be ordered such that the numbers follow the sequence 1,2,3,.... and not 1,10,11,12,....,2,20,21,...
please help

Report | Quote This | Send private message | Reply | Print

Re: Order By clause in query

Posted By:   Anonymous  
Posted On:   Wednesday, April 10, 2002 08:19 AM

That's because the number is stored in a text field. Change the type of the field in the database or convert the field to a number in the order by
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact