SQL Server Data Type

I am using SQL server express as my web site's backend and need to
store more than 8000 characters in a varchar field. When I use
Varchar(Max) the field contents are saved but appear as a single
square in my recordset. What am I doing wrong? The data appears in
the table, but does not appear in my recordset. If I switch the
field
type back to VarChar it works, but only up to 8000 characters.

How do I store more than 8000 characters AND display it through a
recordset on my pages?

Re: SQL Server Data Type

Nevermind....figured it out.