Select * from Clients WHERE (ClientEmailAddress NOT LIKE '%_@__%.__%') AND (LEN(ClientEmailAddress) > 0)