>I did try that, but you cannot assign any value to the text variable.
>"SET @Body =...."

OK, I guess I didn't play with it enough ... but did you try my initial suggestion?

>>you can use a table variable and have the text field as a column. Note that using a table variable is not the same as using a temporary table. <<

~~Bonnie