Re: Sorting in ACE, need help
Try this
SELECT part_no, part_no[8,12] sort_partno, part_descr, part_price FROMstock
ORDER BY 2
This will sort by the figures you are interested in.
Fergus
100554.672@compuserve.com <100554.672@CompuServe.COM> wrote in article
<5j56se$jkq$1@mhadf.production.compuserve.com>...
> 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
>