Sounds to me like you plan to use the varchar(MAX) data type for its intended purpose.
When data in a MAX data type exceeds 8 KB, an over-flow page is used. SQL Server 2005 automatically assigns an over-flow indicator to the page and knows how to manipulate data rows the same way it manipulates other data types.
For further reading, check out Books Online: char and varchar