I seem to remember, and I must stress vaguely, that in SQL it depended on the justification of the left hand operand.
Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. infocusp limited is not responsible for any changes made to this message and / or any attachments after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod Sent: Friday, March 12, 2004 9:58 PM To: U2 Users Discussion List Subject: RE: EVAL The result of every EVAL is (deemed to be) a string. Try using both FMT and CONV field qualifiers. FMT for the right justification and CONV to try to convince the query engine that it's dealing with numbers - either the "MD" or the "MR" conversion should do it. LIST file EVAL "expression" CONV "MD0" FMT "10R" -- 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
