I have a table in SQL 7.0 which has a field called body of the type varchar and length 8000. I have stored some datain n body feild which is 1000 in length. When I retrieve the data in Visual Basic and display the data I get only first 255 chracters. Can somebody explain why this is happening.