CREATE TABLE [test_text] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[vc] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[txt] [text] COLLATE Latin1_General_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO



insert test_text (vc)
select 'hello, number 1'
go

insert test_text (vc)
select 'hello, number 2'
go

update test_text set txt = '12325rfegsfdgervsdfgvsdfgvfdsgv'
where id = 1
go

DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(tt.txt) 
   FROM test_text tt 
      WHERE tt.id = 1 
UPDATETEXT test_text.txt @ptrval 16 1 'b' 
GO

DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(tt.txt) 
   FROM test_text tt 
      WHERE tt.id = 2 
UPDATETEXT test_text.txt @ptrval 16 1 'b' 
GO