Ray Thompson wrote: > 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 Wouldn't that say something like 'ASD9' is a 'number' just because the last character is a digit?
I don't know what kind of bad data I am looking at here. I haven't found a way to pull just an example of a bad record out and doing a brief search of the beginning of the 4 million odd records, I did not see any examples of bad data. I just know when I do a query that scans the entire table expecting these values to be number I get an Oracle error that says it can't because something is not a number. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3038 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
