varchar(8000) or nvarchar(4000) are good character string choices. I doubt
you are going to have a email address or hyperlink that won't fit in that.

--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

*******************************************************************
[quoted text, click to view]

Win 2000 server with Microsoft SQL server 2000
Can anybody help a beginner?
I want to store URLs and email address's hyperlinlinked in the db. So that
when I do a SELECT statement in ASP the results come out hyperlinked in my
table.
Is this possible, what datatype do I use etc.
Thanking you in anticipation
Chris Cowley, Finland