bi publisher and long text fields from sql server

I'm trying to pull in a comments field that is defined as long text in sql server. Nothing shows up when I use this field in a data set, however, if i use substr I can see data, but only 8000 characters at a time. the size of the data is very large, sometimes hundreds of pages. how can i access all the data in a long text field for display on a bi publisher report?