> Unfortunately, I have found the only way to display the result set of a text field is to cast it as a varchar(8000).

I think I had the same problem. I had a 'text' datatype field on an SQL Server and when I tried to response.write the field directly from the recordset, it woundn't print anything. I figured out a trick that if you put the field contents into a memory variable and then response.write the variable, it worked. I'm not sure if this answers your question, but mabey it will help.

Eric Stephani