I have a database of e-mail addresses. I want to select the email addresses which are not valid: do not contain exactly one @ character, contain ; > < " ' , characters or spaces etc. What is the WHERE clause for this ? Andrus. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend