I have a table which has a field of Varchar datatype length 8000 in size. When i do a select query, I only get 256 characters returned where has the field in the table has more than 400 characters. I am using SQL Server 7.0.<BR><BR>Thanks in advance for the help<BR>Sathiya