>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.
varchar(255) or something in that range should do it.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________