Concat Text

[jazerr]

I need to concatenate TEXT. The concatenation will ALWAYS happen at the end of the existing text. ALWAYS.

I cannot make heads or tails of the UPDATETEXT stuff.

Anybody can help?

 

[clapag22]

Does this make it any clearer?

create table my_comments (pkid int not null identity(1,1), comments text)
GO

set nocount on

declare @ptrval binary(16),
	@current_comment_len int,
	@new_comment varchar(8000),
	@pkid int

select @pkid = 1 --or whatever you need it to be to test

select @new_comment = 'this is my new comment'

if exists (select * from my_comments where pkid = @pkid)
	begin

	select @current_comment_len = datalength(comments)
	from my_comments
	where pkid = @pkid	

	select @ptrval = textptr(comments) 
	from my_comments
	where pkid = @pkid

	updatetext my_comments.comments @ptrval @current_comment_len 0 @new_comment

	end

else
	begin
	insert into my_comments (comments) values (@new_comment)
	end

set nocount off

select * 
from my_comments
where pkid = @pkid