I inherited a database with a table that contains records of individuals. In the table is a field named "Email". I would like to somehow loop through the table and identify those records that appear to have an invalid email address. In other words perhaps the @ is missing or the "." is missing or there is a space somewhere in the string of characters, etc.
Has anyone done this before?