In data made available from a state regulatory agency I find a few instances where a facility contact has two email addresses. While multiple locations are accommodated because they're in a table separate from the facility name and details, all people associated with a facility and location are in a 'people' table with only one column for an email addresse.
While I could enter an additional email address in the 'comment' column if I'm entering data for a single facility, I'm reformatting the downloaded data so I can insert all new table data from one .sql file. Is there a way to accommodate multiple email addresses other than entering both with a forward slash separating them in the varchar(64) email address column? Suggestions appreciated, Rich
