>I tried the cast, as you suggested. And it works with the varchar(max) and the Native Client. Here is how I did it:
>

>select (cast myvarchar as text) as myvarchar from my table
>

>And it works! This is TONs of work for me to go through all reports and instead of getting the varchar(max) directly, change it to CAST as Text. But at least there is a solution.

GoFish may be able to help you. I've found its Replace mechanism to be very reliable and you can write custom code to the replacement, if a straightforward replacement won't work for you. Check my article: http://www.tomorrowssolutionsllc.com/Articles/Do%20custom%20replacements%20with%20GoFish.pdf

Tamar