Yes... this is a common issue having to do with exponential notation. For us here it is easy we have 3-digit Stock Bin Locations such as "3E4" and "4F5". Thus, we have to inspect the second digit to be a numeric.
The case there may be somewhat more involved. A little string processing may be needed... --Bill -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, October 16, 2008 4: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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
