In sql server if you want to find the records that aren't numeric you can use:
Select * >From your_table Where isNumeric(fieldToCheck) = 0 -----Original Message----- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 2:52 PM To: CF-Talk Subject: SQL Challenge 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. Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231830 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
