locked
SQL Search Strings and Access RRS feed

  • Question

  • I'm using a email software system that needs a SQL string to work with my access database to pull email addresses from.  I'm trying to filter out certain domains.  This is the string that i have, but something is not correct with it.  If someone has any suggestion on how to fix this string please leave me a message!  Thanks

     

    Select * FROM CMEmailMaster Where Domain_ NOT LIKE *AOL.com AND Where Domain_ NOT LIKE *rr.com AND Where Domain_ NOT LIKE *ATT.net AND WHERE MemberType_ LIKE normal AND WHERE AddressState = PA WV VA AND WHERE NumBounces_ = 0 AND WHERE Remove = 0

    Tuesday, July 10, 2007 6:52 PM