Re: order by clause

Allison Rothmel (ad041_at_Freenet.carleton.ca) wrote:

: I believe this should be a simple command.
 

: I want to ORDER BY fieldname but if the field names are xxx-11, xxx-12,
: xxx-13, xxx-112 and xxx-113 I want them to appear in that order not 11,
: 112, 113, 12, 13 which appears by default.

  One assumes these are alpha-numeric fields sorted alphanumerically, and you want them sorted numerically.

  Try ORDER BY TO_NUMBER(SUBSTR(FIELD1,5)) [Might be a touch on the sluggish side though.]

   Damian Branigan
   (Project Leader ISS)

   d.branigan_at_brookes.ac.uk        "So free we seem, so fettered fast we are."
                                    RB
_______________________________________________________________________________