This is a pretty general question so i didn't have a specific list to send it to, but here goes. I have a web-based mail program that retrieves mail from pop3 servers and sends mail through smtp. Now the question is, what is the best way to store the email addresses? Right now, I have them in a varchar field which is fine, but I've had to grow this field several times and now it has gotten to 5000 chars. This is because some people might want to send a mail merge out to their entire contact list, etc... I can't keep growing this field because I assume that the database would become less and less efficient. So the options I can think of are: - Make the field insanely large. - Use a text/memo field - this would be fine, but makes it hard to search, etc - Use another table to store addresses and map them to the e-mail - What would be the pros and cons of this? The pros I can see are that you could have unlimited number of addresses for each e-mail. Please give your opinion on this. Thanks! Travis Reeder Chief Software Architect www.ThinkVirtual.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
