>>Presently we have a (VFP) table storing email addresses and the field is character (25).
>>
>>What is the recommended length for a character field (other than using memo field)?
>
>See http://email.about.com/od/emailbehindthescenes/f/address_length.htm - 320 is the limit.

thanks

From the below, I am assuming that 50 should be more than enough, but was looking for suggestions from others.


length | min max---------------------
68.26% | 15.48 | 23.66
95.45% | 11.39 | 27.75
99.73% | 7.48 | 31.84

dated January 16, 2007



averages:
22.01 for 12.5 million unverified addresses
29.49 for 964 thousand verified addresses