List:General Discussion« Previous MessageNext Message »
From:Sagar C Nannapaneni Date:January 23 2004 12:49pm
Subject:Order by problem
View as plain text  
Hi all,

I have an ID field in my database...it reads like this

ASS1
ASS23
ASS4
ASS10
ASS6
.
.
.

when i'm retrieving the data by taking ORDER BY clause it is sorting like this

ASS1
ASS10
ASS23
ASS4
ASS6

means its only sorting by the 4 the character. i want the sorting to be done like the
following

ASS1
ASS4
ASS6
ASS10
ASS23

Solutions are greatly appreciated

thanks in adavance

/sagar

Thread
Order by problemSagar C Nannapaneni23 Jan
  • Re: Order by problemMartijn Tonies23 Jan
  • Re: Order by problemBenoit St-Jean23 Jan
  • Re: Order by problemFrederic Wenzel23 Jan
    • SELECT statementGary Broughton23 Jan
    • Re: Order by problemmos23 Jan
  • Re: Order by problemmos23 Jan