My take on this is that the NUMERIC function is for making sure the contents of "TEXT" can be used in an arithmetic expression (Which 2E-29 can).
If you want to test if "TEXT" is not all digits, then maybe the following would be more appropriate IF TEXT MATCHES "~0N" THEN PRINT "NOT NUMERIC" Rod Hills -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, October 16, 2008 1:08 PM To: u2-Users Subject: [U2] [UV] What is this? I just had a buddy call me to have me test something on my system that he got bitten with. Anyone else ever been bitten by this? TEXT = '2E-29' ;* Expected to be TEXT IF NUMERIC(TEXT) THEN PRINT 'IS NUMERIC' END ELSE PRINT 'NOT NUMERIC' END ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ___________________________________________________ This e-mail and any attachments are for the sole use of the intended recipient(s) and may contain privileged and confidential information. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient(s), please contact the sender by reply e-mail and destroy all copies of the original message. Thank you. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
