I am trying to do a query on phone numbers. The format of the phone numbers are supposed to look similar to 000-000-0000. Most are but
there are several that are like the following and may not have just straight zero's.
How can I get my query to bring back all phone numbers except the phone numbers that have the 3 format styles I listed above? I have tried using "Like" and using "Not Like". This is not working. Is there some SQL that I need to write and if so, what is it?