content addition to a text column

[Fatih235]

hey all;

i have a column "story" which is text datatype.It has some content in it. I would like to do this;

update story_table
set story=story + 'blah blah blah'
where story_id in(1,2,3)

i am getting an error of datatype error. How can i fix it?

 

[mimi2]

something like this:

declare @story varhar(800)

set @story = (select story from story_table where story_id = 1)

update story_table
set story= @story + 'blah blah blah'
where story_id in (1,2,3)