Unfortunately, in my case, we can't pre-process the data as it is a 3rd party application that populates the SQL table. We're just trying to export the data as...

Thanks for your opinion, Paul. Do you have any suggestions for converting RTF text that resides in an NTEXT column to plain text other than the solution given above?

Thank you!

I used a subset of your script to:

1.) Set the database trustworthy

2.) Drop the System.Windows.Forms assembly if it existed

3.) Created the System.Windows.Forms assembly

Because I ran into some problems manually...

Hi Joe,

Can you tell me how you were able to reference System.Windows.Forms namespaces in your CLR function? I'm a newbie at this and I've been looking for a CLR...