Where not Left(LTrim(RTrim(column_name)),1) between '0' and '9' Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578
-----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, February 22, 2008 1:50 PM To: SQL Subject: find non-numbers I have a table with a few million records. Somewhere buried in there is at least one, probably many more data fields that should be a number but are not. The actual field type is varchar2(), but it is supposed to contain numeric data. This is not going to change, this data has existed as it is since 1974 and nobody is going to change it at this time. How can I find and|or filter out these non-number numbers so that I can join this data to another field that is a proper number(5) field? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3037 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
