I tried this for my business scenario. We were expecting the columns are filled with '(' or ')' or '-'
select
pid,phonenumber,contacttypeid,l.lookupvalue
from
memberphone mp
,lookup l
WHERE
REGEXP_LIKE(phonenumber, '()-')
and l.lookupid = mp.contacttypeid
slightwv (䄆 Netminder)
Finding non-numeric versus finding non-valid phone numbers are two different questions.
Non-numerics can be found with any of the first three posts and answers the question asked.
If you now need to find invalid phone numbers, I suggest you close this question by choosing all or what you consider the best method of findind non-numerics and open a new question and provide more detailed requirements.
You would need to specific ALL the valid masks for a phone number.
d27m11y d27m11y
ASKER
Thanks for the help and it helped me resolve my issue
http://cwbrian.wordpress.com/2007/03/30/oracle-check-for-any-non-numeric-value-in-a-column/