>I am back to my SQL Server project (which was on a back burner for a while). So for those who don't want to read newbie questions, put me in a twit <g>.
>
>I am creating a table where one of the fields is Email Address. In my VFP table I used a 100 Char type field. Which is probably a lot of waste since only a few emails would be so long. What type and what length would you recommend for email address?
>
>Thank you.
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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.