I have seen many people ask about this problem I am having with no solution. Please Help!!. I am using SQL7.0 with a varchar field of 1000 characters. In my asp page my recordset only returns the first 255 characters of the field. In fact the field properties in the recordset show it as 255 characters? What am I doing wrong. I want the entire 1000 characters. Please Help!!