I have a field called NewProductLink that I am inserting a long hyperlink into. It is of data type varchar and I have set the length to 500. It seems no matter the length I set the field to it cuts off the data of that column at 255 characters as far as I can tell. Is this a limitation of sql server 2000 or am I doing something wrong? Please advise.

Hi there,

Usually when these kind of things happen, it's the code or stored procedure that cuts of the text.

Are you using a stored procedure? Did you define the parameter for the URL as a varchar(255)

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

How do you know the data has been "cut off"? Are you using Query Analyzer to view it? If so, QA has a configurable option which limits the number of characters per column displayed (Tools->Options->Results). Try a different setting...

Jeff Mason
[email protected]