Re: Sorting in ACE, need help
100554.672@compuserve.com wrote:
> 137600-22300
> 139653-54210
> 141616-42061
> ^
> I need to have those part no's sorted by the figures after the
> stroke. Got my point?
If they are all in a fixed format like the above, then
select part_no, part_no[8,12]
order by 2
or even:
order by 2,1
Good Luck,
Douglas Wilson