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

    Unanswered: Getting Rid of Bad Data in Query

    I have Phone numbers in my data that are similar to the following:

    10-123-5693
    0-000-0000
    000-000-0000
    -293-458-4853
    999-999-9999
    302-000-0000
    410-000-0000
    856-000-0000
    5-000-0000
    0-000-0008

    I have figured out how to get pretty much all the bad numbers to show by using

    Like "???-000-0000"
    Like "???-999-9999"
    Not Like "???-???-????"
    Is null

    I need to create a query showing all the good numbers now. I would think it would be the total opposite of the above but that is not working at all. Any Suggestions?

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    if you can get the bad guys to show up in a query, use the Find Unmatched query wizard to see how it's done.

    you want to return from your table all that is not found in your bad-guy query.

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Apr 2004
    Posts
    11
    That helped. Thank you.

Posting Permissions

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