Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    11

    Exclamation Unanswered: Querying by specific format

    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.

    -000-000-0000
    00-000-0000
    0-000-0000

    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?

  2. #2
    Join Date
    Feb 2004
    Posts
    137
    Try: Like '???-???-????'

    ...for your criteria in your query, and see if this returns the desired result.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •