Yes but its not the same, and doesn't help if the EVAL result can be negative (unless you add a large enough number to it to make all results positive).
________________________________ From: [EMAIL PROTECTED] on behalf of Randy Gill Sent: Thu 3/11/2004 3:50 PM To: U2 Users Discussion List Subject: RE: EVAL Okay. Alternately, perhaps something like this would work (again, works on UniVerse...): LIST CUSTOMER NAME BY.DSND EVAL "FMT(LEN(NAME),'2R')" Randy -----Original Message----- From: Dave Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 2:53 PM To: U2 Users Discussion List Subject: RE: EVAL 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
