My logic is faulty. Story of my life. Anyway, I have the following query, which I believe is failing during the multiple string checks in one column. I want to be able to check for multiple strings in one column with the `AND` operator.

Example, I want to suppress this email "dick1sucker@gmail.com" but I don't want to suppress "dickeynewman@gmail.com". Using the `AND` operator below, it appears as if a record is suppressed if either one of the string checks occurs, even though I've surrounded the statement with parentheses. 

```
/****** Script for CHECK DOMAIN SUFFIX AND VULGARITIES  ******/

SELECT EMAIL

INTO Matched_Table

FROM Matched_Table_TEMP

WHERE (RIGHT(RTRIM(EMAIL),4) IN ('.COM','.NET','.MIL','.GOV','.ORG','.BIZ') OR RIGHT(RTRIM(EMAIL),3) = '.US')

AND (CHARINDEX('DICK',EMAIL) = 0 and CHARINDEX('SUCKER',EMAIL) = 0)

AND (CHARINDEX('DICK',EMAIL) = 0 and CHARINDEX('HEAD',EMAIL) = 0)

AND (CHARINDEX('DICK',EMAIL) = 0 and CHARINDEX('CHOKE',EMAIL) = 0)

AND (CHARINDEX('DICK',EMAIL) = 0 and CHARINDEX('FACE',EMAIL) = 0)

AND (CHARINDEX('DICK',EMAIL) = 0 and CHARINDEX('NOSE',EMAIL) = 0)

AND (CHARINDEX('COCK',EMAIL) = 0 and CHARINDEX('SUCKER',EMAIL) = 0)

```

I will be adding plenty more vularities to the list, but obviously need the logic corrected first.

Another example, right now the above suppresses the following emails, but I don't want them suppressed.

METALHEAD038@HOTMAIL.COM

BAND2FACEDKITTY@AOL.COM

ANGELFACE30\_98@YAHOO.COM

TERESADICKSON921@HOTMAIL.COM

ROARINGARTICHOKE@TOMGREEN.COM

CERNOSEK@YAHOO.COM