Order by Question

Results 1 to 2 of 2

Thread: Order by Question

  1. #1
    Join Date
    Dec 1969

    Default Order by Question

    Hello,<BR>I know the default for order by is ASC order but my problem is this. When i run this statment:<BR>select Section_id,Question_num,Question from Questions where section_id =&#039;3&#039; Order By Question_Num <BR><BR>the results are:<BR>1<BR>10<BR>11<BR>12<BR>.<BR>.<BR>2<BR>20<B R><BR>I am definitly missing something, any suggestions?<BR>thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Order by Question

    It sounds like your Question_Num column is a character field instead of a numeric one.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts