QTP 6.07F on AS/400 sort sequence

clarele clarele@attbi.com
Thu, 24 Apr 2003 12:11:32 -0700


Hi Dan......numbers sort first....but not totally as you would think.
1
10
11
.
2
20
21
.
then the alpha characters.

Have fun,
Clare

----- Original Message -----
From: "Daniel Mielke" <DMielke@aic.com>
To: "Powerhouse List (E-mail)" <powerh-l@cube.swau.edu>
Sent: Thursday, April 24, 2003 11:32 AM
Subject: QTP 6.07F on AS/400 sort sequence


> Hi all,
>
> Is the sort sequence for PH fixed or system determined?
>
> I have an alphanumeric field that contains A-Z as well as 0-9.  So for
> example, I have three records as below, what would the PH sort order be
for
> "sort on alpha-data-field"?
>
> alpha-data-field
> AJONES
> aJONES
> 1JONES
>
>
> > BUY. HOLD. AND PROSPER.
> >
> > Daniel Mielke
> > Business Systems Analyst
> > AIC Limited
> > 1-888-710-4242 (4614)
> > dmielke@aic.com
> > www.aic.com
> >
> >
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.