Search This Blog

Wednesday, January 13, 2010

Append to a text blob in SQL 2008

From StackOverflow
Wish I could remember this without google...


update 
  tablename
set
  fieldname = convert(nvarchar(max),fieldname) + 'appended string'


No comments: