Text data-type is one way to go on that. The other is to vertically partition the table.
If, for example, the table has an ID column, then you have the "main table" with the ID and all the columns except the two varchar(8000) columns, then you have two other tables, each has just the ID and one of the varchar(8000) columns. The other two have FK with cascading delete to the main table.
Makes inserts and updates a little more complicated, but allows you to have the data the way you need.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon