Append to a text field

[Ryan Langton]

Is there any way with T-SQL to append to a text field?

Thanks,
Ryan

 

[Ryan Langton]

Nevermind it is simple.
"UPDATE table.field SET field = field + N'Appended Text' WHERE <condition>"

 

[Philipp Stiefel]

Is there any way with T-SQL to append to a text field?

Yes, have a look at the TEXTPTR function and the UPDATETEXT
command.

HTH
Phil