Retreiving specific content in a Database table field
Posted by: Airwe Josh
Date: June 28, 2010 11:19AM

I require a solution:
I have a large database storing among many things GPS codes. The codes are in 7 digits. However users have been entering less or more than seven digits worse still some have entered letters and spaces. I need a query that can pull only such erroneous records for editing. Using length() function i have been able to deal with the less or more than 7 digits however i am no seeking a solution for checking whether letter have been entered.

Thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
Retreiving specific content in a Database table field
3765
June 28, 2010 11:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.