Is there any way with T-SQL to append to a text field? Thanks, Ryan
R Ryan Langton Feb 15, 2006 #2 Nevermind it is simple. "UPDATE table.field SET field = field + N'Appended Text' WHERE <condition>"
P Philipp Stiefel Feb 15, 2006 #3 Ryan Langton said: Is there any way with T-SQL to append to a text field? Click to expand... Yes, have a look at the TEXTPTR function and the UPDATETEXT command. HTH Phil
Ryan Langton said: Is there any way with T-SQL to append to a text field? Click to expand... Yes, have a look at the TEXTPTR function and the UPDATETEXT command. HTH Phil
