Re: Sorting in ACE, need help

100554.672@compuserve.com <100554.672@CompuServe.COM> wrote: :Hope someone can help me. :We are using Informix SE 7.1 and I need to create a report (with :ACE) in which some rows of part no's need to be sorted. So far :its easy, I just use : : :SELECT part_no, part_descr, part_price FROM stock :ORDER BY part_no : :The problem is that the part no's look like: : :137600-22300 :139653-54210 :141616-42061 : ^ :I need to have those part no's sorted by the figures after the :stroke. Got my point? You should be able to do: SELECT part_no[8,12], part_no, part_descr, part_price FROM stock ORDER BY 1 Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org