This is bizarre!

I had a group created using a query builder to pick all the invalid emails.  It had 618 contacts in this group.  I changed the layout to add create date and modify date for these contacts and what I now see is a list of 6172 contacts.  I haven’t modified the conditions but only the layout.

I have deleted the create and modify dates and it still remains the same.  Can you please let me know how to get back my original list that shows 618 contacts of invalid emails.

Thanks?

Please post the group's SQL.

Thanks Phil,

Here it is

SELECT A1.CONTACTID, A1.EMAIL, A1.NAMELF, A1.ACCOUNT, A2.CITY A2_CITY, A2.STATE A2_STATE, A1.TITLE, A1.WORKPHONE, A1.MOBILE, A1.ACCOUNTMANAGERID, A1.CREATEUSER, A1.NAME, A1.NAMELF FROM CONTACT A1 INNER JOIN ADDRESS A2 ON (A1.ADDRESSID=A2.ADDRESSID) WHERE ((A1.EMAIL LIKE  '%#%') OR (A1.EMAIL LIKE  '%$%') OR (A1.EMAIL LIKE  '%^%') OR (A1.EMAIL LIKE  '%&%') OR (A1.EMAIL LIKE  '%(%') OR (A1.EMAIL LIKE  '%)%') OR (A1.EMAIL LIKE  '%+%') OR (A1.EMAIL LIKE  '%=%') OR (A1.EMAIL LIKE  '%{%') OR (A1.EMAIL LIKE  '%[%') OR (A1.EMAIL LIKE  '%}%') OR (A1.EMAIL LIKE  '%]%') OR (A1.EMAIL LIKE  '%\%') OR (A1.EMAIL LIKE  '%|%') OR (A1.EMAIL LIKE  '%;%') OR (A1.EMAIL LIKE  '%:%') OR (A1.EMAIL LIKE  '%,%') OR (A1.EMAIL LIKE  '%<%') OR (A1.EMAIL LIKE  '%>%') OR (A1.EMAIL LIKE  '%?%') OR (A1.EMAIL LIKE  '%/%') OR (A1.EMAIL LIKE  '%%') OR NOT (A1.EMAIL LIKE  '%@%')) AND (A1.EMAIL IS NOT NULL AND A1.EMAIL <> '') ORDER BY A1.NAMELF ASC

Thanks Phil.

Here it is.

SELECT A1.CONTACTID, A1.EMAIL, A1.NAMELF, A1.ACCOUNT, A2.CITY A2_CITY, A2.STATE A2_STATE, A1.TITLE, A1.WORKPHONE, A1.MOBILE, A1.ACCOUNTMANAGERID, A1.CREATEUSER, A1.NAME, A1.NAMELF FROM CONTACT A1 INNER JOIN ADDRESS A2 ON (A1.ADDRESSID=A2.ADDRESSID) WHERE ((A1.EMAIL LIKE  '%#%') OR (A1.EMAIL LIKE  '%$%') OR (A1.EMAIL LIKE  '%^%') OR (A1.EMAIL LIKE  '%&%') OR (A1.EMAIL LIKE  '%(%') OR (A1.EMAIL LIKE  '%)%') OR (A1.EMAIL LIKE  '%+%') OR (A1.EMAIL LIKE  '%=%') OR (A1.EMAIL LIKE  '%{%') OR (A1.EMAIL LIKE  '%[%') OR (A1.EMAIL LIKE  '%}%') OR (A1.EMAIL LIKE  '%]%') OR (A1.EMAIL LIKE  '%\%') OR (A1.EMAIL LIKE  '%|%') OR (A1.EMAIL LIKE  '%;%') OR (A1.EMAIL LIKE  '%:%') OR (A1.EMAIL LIKE  '%,%') OR (A1.EMAIL LIKE  '%<%') OR (A1.EMAIL LIKE  '%>%') OR (A1.EMAIL LIKE  '%?%') OR (A1.EMAIL LIKE  '%/%') OR (A1.EMAIL LIKE  '%%') OR NOT (A1.EMAIL LIKE  '%@%')) AND (A1.EMAIL IS NOT NULL AND A1.EMAIL <> '') ORDER BY A1.NAMELF ASC

Jai

The problem is this Condition:

   OR (A1.EMAIL LIKE '%%')

This condition includes all Valid Email Addresses onto your Group's resultset.

Doesn't this (A1.EMAIL LIKE '%%') mean email field with no email addresses entered.   We also want to include this condition where there are no email addresses.

You are absolutely right.  It was rectified when OR was changed to AND.

Thanks a lot for the tip.  You are a wealth of information on Saleslogix.

Jai