The Joys Of NText...

So, here's the conundrum.

We have ProcA that uses nText as one of it's parameters. It works fine.

I'm writing ProcB, that calls ProcA and also accepts nText as a parameter.

Unfortunately, I have to do a string replace in that nText field. But, I've got that sorted out, with a little UPDATETEXT voodoo.

My input parameter, now exists unchanged as @Body and in #nText.txt with all the modifications completed.

The problem, is I need to pass that #nText.txt value as a parameter to ProcA.

I can't use 'SELECT @Body = txt FROM #nText' because I get an assignment error (can't assign nText values).

And I can't seem to call ProcA with the value from the table directly.

What can I do? I'm 99% there, I just need to take this last step and I can put this garbage behind me.

Thanks
-C



ps SQL2000