Robert Everland III wrote: > Is there a way in MSSQL and Oracle or either that will allow you to do a > select on a varchar field and be able to see if that record can be converted > to a number? We have a ton of databases that used varchar to handle numbers > and are getting issues now that some records have gotten data other than a > number in them. I want to convert them to an integer field but can't do that > until we fix the problem records.
You mean like the Transact-SQL function isNumeric()? SELECT CompanyName, PostalCode, isnumeric(PostalCode) AS 'PostCodeIsNumeric' FROM suppliers http://www.brettb.com/SQL_Help_IsNumeric_Function.asp (first result in the following google search: http://www.google.com/search?hl=en&q=isnumeric+transact-sql ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231828 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
