Insert URL

Hello,

I would like to include a URL hyperlink into my database, I have select nvarcher as the data type. Is this correct. Iif not what is the correct format for the user to use as a hyperlink?

However, because some of the URL's are very, very long, is there some way I can use html and just say "Click Here" and the user will be taken to the correct page? If so, how could this be achieved, how could I insert html?

Or is there a better way of inserting links.

If so please advise.

Thanks.

Lynn

As far as the db is concerned, it doesnt mattet if its a hyperlink or html. its just data. since there can be special characters, you could use varchar. Now if you want the text to appear as a link on the webpage you would need to use an anchor tag. Thats something to be taken care of at the front end level.|||

You might want to read this first...

http://thedailywtf.com/forums/70666/ShowPost.aspx