There're many more top level domains than .COM and .NET, like .ORG, .US, etc.
Anyway, you can use LIKE operator or PATINDEX()/CHARINDEX() functions to check for presence of one string inside another. See BOL for details.


>I have a table with a field called email.
>I would like to make sure that all email are valid.
>How can I build a select statement that will return all the records that do not have a .com or .net in the email field.
>
>Select * from emails WHERE ".com" OR ".net" is not in the email field
>