RE: Sorting in ACE, need help

try select part_no[1, 6], part_no[8,12], part_descr, part_price from stock order by 2 HTH, Marco ____________________________________________________________________________ rem radioterapia, which I immeritately manage, seldom agrees with what I say marco greco (Catania, Italy) Work: marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558 (was mar.greco@agora.stm.it) Achea 39 95 503117 --- On 17 Apr 1997 12:59:58 GMT "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? Any Idea? Any help/suggestion appreciated. Ronny -----------------End of Original Message-----------------