I have a SQL Server 7.0 DB table that contains varchar and text fields. When I try to display the fields' values using ASP, some fields appear and others do not appear. When I set all fields as varchar in the table, all the fields are displayed without any<BR>problem. Two fields need to be text because each field needs to accommodate at least 6000 characters of data. If I use varchar for all the fields then I am limited to the 8060 character row size. I really want to use only one table. Thanks for your help. I look forward to your reply.