Hi<BR><BR>I have a problem with retrieving text from my SQL Server DB via ASP. I have a field set to "varchar" data type (supposedly supports up to 8000 characters) that has approx 500 chars in it.<BR><BR>When the results of a query are shown, the text returned is always only 255 chars!<BR><BR>I then attempted to get around this by setting the fields data type to "text". However, now I can&#039t retreive anything from this field unless it is the last item in my query string.<BR><BR>Anyone know a way around this? I would prefer to use "varchar" instead of "text" if at all possible.<BR><BR>Regards, Eli.<BR><BR>