Hi all !!!

I have a very big trouble. I must form conents of the text-fiels from the
stored procedure (Transact SQL). But I did not find any means for it in
Transact SQL. WriteText does not write so good how it is need me. How I can
write the variable more 255 bytes or how I can modify the existsing
text-field with information. Suppose we have the text-field with the next
string 'dsdsdg...agfjgasfjgd' (1000 symbols) and I want to add yet in the
end of this field. What I must to do?
And the second, How I can read from the text-field (readtext is a stream
function and it is impossible to use it inside the stored procedure.)

I did not find any in the documentation.