Append to a text field

  • Thread starter Thread starter Ryan Langton
  • Start date Start date
Nevermind it is simple.
"UPDATE table.field SET field = field + N'Appended Text' WHERE <condition>"
 
Ryan Langton said:
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
 
Back
Top