>
>use varchar(100), I doubt that somebody will have 100 chars as eMail (who will wrote Him/Her?) but varchar keeps the data trimmed and there is no waste of space. :-)
>Keep in mind that you must pass the data trimmed from your FrontEnd.
100 is probably OK, but I've seen some incredibly long email addresses (mostly from US government agencies) before so I like to have enough space...
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________