Then try this idea: EVAL "FMT(LEN(NAME),"R#4")" AS SORTORD BY.DSND SORTORD
Stu Glancy Asset Management Outsourcing, Inc. Senior Analyst/DBA 770-792-3907 > Tried that before and it still sorted left (on UniData). That's why I > asked. > > ________________________________ > > From: [EMAIL PROTECTED] on behalf of Randy Gill > Sent: Thu 3/11/2004 3:27 PM > To: U2 Users Discussion List > Subject: RE: EVAL > > > > Yes, I use this feature often in UniVerse (running in PI/OPEN flavor). > > Suppose I wanted to list the customers with the longest names, I would > use: > > LIST CUSTOMER NAME BY.DSND EVAL "LEN(NAME)" FMT "2R" > > Since the default is left justification, if I omitted the 'FMT "2R"', > all the customers with 9-character names would be sorted before those > with 10+ character names! The FMT clause causes it to sort as one would > expect. > > Hope this helps. > > Randy > > -----Original Message----- > From: Dave Davis [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 11, 2004 9:23 AM > To: U2 Users Discussion List > Subject: RE: EVAL > > On the use of FMT to affect the justification of an EVAL field, can this > be used to affect a sort by an EVAL field? It doesn't seem to affect it > when I do it in unidata. > > > Our company accepts no liability for the content of this email, or for > the > consequences of any actions taken on the basis of the information > provided, unless that information is subsequently confirmed in writing. > Any views or opinions presented in this email are solely those of the > author and do not necessarily represent those of the company. > WARNING: Computer viruses can be transmitted via email. > The recipient should check this email and any attachments for the > presence of viruses. The company accepts no liability for any damage > caused by any virus transmitted by this email. > 11/29/2003 ACE Software, LLC > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
