Append A Field

Hello,





How do I append data on an update?


I have a table with a field that is nVarchar(1000) and the initial insert is a few sentences. If I wanted to add to that row using an update statement and without starting at the end of the sentences, how would I write that?





Update table set fieldname = 'more data' where value = @variable





instead of





Update table set fieldname = 'initial data more data' where value = @variable





and the 'more data' appends to the initial data... hmmm





help please.