Mail Id-how to store?

Hi,
How to store email address in SQL Server and is there a special data type
for it and whats the maximum limit that can be stored?
Kindly help me.
Regards,
Shyam
Hi,
Use the data type VARCHAR. The maximum limit is 8000 characters. I recomment
you to have 120 bytes for email storage maximum.
Declare @.emailid varchar(120)
Tahnks
Hari
SQL Server MVP
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:412215F3-FF74-4BFB-988B-7A2C55E2812D@.microsoft.com...
> Hi,
> How to store email address in SQL Server and is there a special data type
> for it and whats the maximum limit that can be stored?
> Kindly help me.
> Regards,
> Shyam
|||See if this helps:
http://vyaskn.tripod.com/handling_em...sql_server.htm
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:412215F3-FF74-4BFB-988B-7A2C55E2812D@.microsoft.com...
Hi,
How to store email address in SQL Server and is there a special data type
for it and whats the maximum limit that can be stored?
Kindly help me.
Regards,
Shyam