RE: Sort Sequence on a LF

["Kahn, David [JNJFR]" <DKahn1@xxxxxxxxxxxxx>]

Jay,

That's not going to bring character field "21 " before character field
"200".

Dave Kahn
Johnson & Johnson International (Ethicon) France
Phone : +33 1 55 00 3180
Email :  dkahn1@jnjfr.jnj.com (work)
           dkahn@cix.co.uk      (home)



-----Message d'origine-----
De: Jay Myrick [mailto:jmyrick@netdoor.com]
Date: 20 July 1999 01:09
À: RPG400-L@midrange.com
Objet: RE: Sort Sequence on a LF


Why not replace *BLANKS with *LOVALS. That has worked for me in the past.

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of fkolmann@revlon.com.au
Sent: Monday, July 19, 1999 3:29 AM
To: RPG400-L@midrange.com
Subject: Re: Sort Sequence on a LF




JFinney@omnia.co.za wrote:

>
> Question : How can I change this sort sequence to sort :
>
> *blanks, a, A,1, 10, 21, 200 ?
>

Not really possible.  It looks like you need a numeric sort with fields that
contain alphas.  If I had to do something I would set up a numeric field and
RPG MOVE the above keys to the numeric field and create a lgl on the numeric
field.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *