Posted by Erland Sommarskog on 10/26/05 01:13

(rey@infoman.de) writes:
>
> thanks for your answer.
> With exec(@return+@onelevel) I try to fill my @return variable with
> the content of @onelevel. I can't do it with set @return=@onelevel
> because @return is of type ntext.
>
> How can I do it else?

You can't. Since you are in a dead end, I suggest that you explain
your underlying business problem that you are trying to solve. What
does the calling side of this look like?

I can offer one workaround: move to SQL 2005, which offers the
new datatype nvarchar(MAX), which in difference to ntext is a first
class citizen.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]