CREATE PROCEDURE dbo.APPEND_THINGY
@id int,
@new_text varchar(8000)
AS

DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(item) 
   FROM table 
   WHERE id = @id

UPDATETEXT table.item @ptrval NULL 0 @new_text;

GO