Notes

SELECT FINAL.[Company Name], FINAL.[First Name], FINAL.[Middle Name], FINAL.[Last Name], FINAL.[Contact Name], FINAL.[Address], FINAL.[City], FINAL.[State], FINAL.[QC_Details]
FROM FINAL
WHERE (((FINAL.[Company Name]) In (SELECT [Company Name] FROM [FINAL] As Tmp GROUP BY [Company Name],LEFT([First Name],3) HAVING Count(*)>1 And LEFT([First Name],3) = LEFT([FINAL].[First Name],3))))
ORDER BY FINAL.[Company Name], FINAL.[First Name];





SELECT FINAL.[Company Name], FINAL.[Last Name], FINAL.[Contact Name], FINAL.[First Name], FINAL.[Middle Name], FINAL.[Address], FINAL.[City], FINAL.[State], FINAL.[QC_Details]
FROM FINAL
WHERE (((FINAL.[Company Name]) In (SELECT [Company Name] FROM [FINAL] As Tmp GROUP BY [Company Name],LEFT([Last Name],3) HAVING Count(*)>1 And LEFT([Last Name],3) = LEFT([FINAL].[Last Name],3))))
ORDER BY FINAL.[Company Name], FINAL.[Last Name];




SELECT FINAL.[Company Name], FINAL.[First Name], FINAL.[Last Name], FINAL.[Contact Name], FINAL.[Middle Name], FINAL.[Address], FINAL.[City], FINAL.[State], FINAL.[QC_Details]
FROM FINAL
WHERE (((FINAL.[Company Name]) In (SELECT [Company Name] FROM [FINAL] As Tmp GROUP BY [Company Name],LEFT([First Name],3),LEFT([Last Name],3) HAVING Count(*)>1 And LEFT([First Name],3) = LEFT([FINAL].[First Name],3) And LEFT([Last Name],3) = LEFT([FINAL].[Last Name],3))))
ORDER BY FINAL.[Company Name], FINAL.[First Name], FINAL.[Last Name];





select distinct title from final
where
Not (
InStr(final.title, "director") > 0
or
InStr(final.title, "manager") > 0
or
InStr(final.title, "chief") > 0
or
InStr(final.title, "head") > 0
or
InStr(final.title, "president") > 0
or
InStr(final.title, "chairman") > 0
or
InStr(final.title, "owner") > 0
or
InStr(final.title, "founder") > 0

)



select distinct title from final




SELECT [FINAL].* FROM [FINAL]
WHERE
NOT EXISTS (
SELECT [phontab].[area code] FROM [phontab]
WHERE
Left([FINAL].[phone number],3) = [phontab].[area code]
AND
[FINAL].[state] = [phontab].[state]
)
AND FINAL.[Phone Number] NOT LIKE "899*" AND FINAL.[Phone Number] NOT LIKE "888*"
AND FINAL.[Phone Number] NOT LIKE "877*" AND FINAL.[Phone Number] NOT LIKE "866*"
AND FINAL.[Phone Number] NOT LIKE "855*" AND FINAL.[Phone Number] NOT LIKE "844*"
AND FINAL.[Phone Number] NOT LIKE "833*" AND FINAL.[Phone Number] NOT LIKE "822*"
AND FINAL.[Phone Number] NOT LIKE "811*" AND FINAL.[Phone Number] NOT LIKE "800*"






SELECT S.*
FROM (
SELECT [First Name], [Last Name], Left(Email, InStr(Email, '@') - 1) As Epart, [Contact Name], Email, [QC_Details]
FROM FINAL
) As S
WHERE S.Epart Not Like ("*" & Left(S.[First name],3) & "*") And S.Epart Not Like ("*" & Left(S.[Last name],3) & "*");





SELECT *
FROM Final
where
final.email Like "*[!-._@a-zA-Z0-9]*"



SELECT *
FROM Final
where
FINAL.Email Like "*__*" or FINAL.Email Like "*--*" or FINAL.Email Like "*..*" or FINAL.Email Like "*@@*" or FINAL.Email Like "*." or FINAL.Email Like ".*" or FINAL.Email Like "*@" or FINAL.Email Like "@*" or FINAL.Email Like "*-" or FINAL.Email Like "-*" or FINAL.Email Like "*_" or FINAL.Email Like "_*" or FINAL.Email Like "*.@*" or FINAL.Email Like "*@.*" or FINAL.Email Like "*-@*" or FINAL.Email Like "*@-*" or FINAL.Email Like "*_@*" or FINAL.Email Like "*@_*" or FINAL.Email Like "*.-*" or FINAL.Email Like "*-.*" or FINAL.Email Like "*._*" or FINAL.Email Like "*_.*" or FINAL.Email Like "*-_*" or FINAL.Email Like "*_-*" or FINAL.Email Like "*@*@*" or FINAL.Email Not Like "*@*.*"