Find phone numbers with unneeded characters

Hi, our system allows users to enter extra characters when inserting or altering phone numbers in our database. This has led to phone numbers to be saved with comments, spaces, etc. The saved phone number should contain 10 numeric characters. I need to run a query to find all records that do not follow this pattern.

Thank you.
horaliaAsked:
Who is Participating?
 
radcaesarCommented:
This is for north american formatting, Change it to your format as needed

http://www.codeproject.com/KB/database/SQLPhoneNumbersPart_2.aspx?display=Print
0
 
Ephraim WangoyaCommented:

You can use regular expressions to do that
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.