Worked like a charm. Thanks so much for the suggestion, Karen!
Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: Karen Tellef <[email protected]> To: [email protected] (RBASE-L Mailing List), Date: 10/10/2014 12:52 PM Subject: [RBASE-L] - Re: Searching for invalid DOUBLE data types Sent by: [email protected] I haven't tested this, but here's a thought. If you do a select std_prod_scrap, (CTXT(std_prod_scrap)) FROM <table> does the text column show the scientific notation? If so, then you could say "where slen(ctxt(std_prod_scrap)) > 6" or something like that Karen -----Original Message----- From: mike.ramsour <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, Oct 10, 2014 11:29 am Subject: [RBASE-L] - Searching for invalid DOUBLE data types Good afternoon: Is there a way to search a DOUBLE data type column to find entries that have been stored in scientific notation? I discovered this anomaly in one of my databases when I did a reload on it. Here's an example: UNIT_NO INWGT OUTWGT STD_PROD_SCRAP COQ_PROD_SCRAP -------- --------------- --------------- --------------- --------------- 4116 282,100 278,055 724.08 4425.75 4117 193,145 192,955 34. 162.5 7103 5,683 5,683 -2.220446E-16 0. 7106 5,617 5,644 -4.86 -31.86 7107 5,472 5,463 1.62 10.62 I can ferret these entries out in a tedious manner by comparing the original database to the rebuilt one but I was hoping for a more expedient method. Thanks for any suggestions. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
