viewing contents of field type "long text"

I am writing vbscript code in an .asp page. I need to display field values
from a sql table consisting of several fields, one of them is of type "Long
Text". This field contains XML data. I like to be able to assign vale of
this field to a variable, display it and write out a text file using file
streaming object.

When I set a variable to this field, the data is truncated. I am using
"Recordset" object, is that not an appropriate type to retrieve
fields.

Any help will be appreciated.
Thanks,
Paul