declare @ptrval BINARY(16);
declare @position int;
declare @length int;
SELECT @ptrval=TEXTPTR(LSD_Comment),@length=datalength(LSD_Comment),@position=PATINDEX('%a%',LSD_Comment) FROM Legal_Dispute WHERE LD_Record_No=25;
UPDATETEXT Legal_Dispute.LSD_Comment @ptrval @position 0 N'No Change By angle on 3/26/2003 11:16:36 AM '
SELECT LSD_Comment FROM Legal_Dispute WHERE LD_Record_No=25;
declare @ptr varbinary(16),@len int,@i int
set @i=(select max(a) from #t)
while (@i>0)
begin
select @len=datalength(r1),@ptr=TEXTPTR(r1) from #t where a=@i
if @@rowcount>0
begin
declare @bb int,@cc int
select @bb=0
select @cc=charindex('a',r1) from #t where a=@i
while @cc>0
begin
set @bb=@cc+1
select @cc=charindex('a',r1,@bb) from #t where a=@i
updatetext #t.r1 @ptr @cc 1 'c'
end
declare @ptrtext varbinary(16)
begin tran
select @ptrtext = TEXTPTR(r1) from t(UPDLOCK)
where id = 1;
if @ptrText is not null
UPDATETEXT t.r1@ptrtext 0 NULL 'This is a try'
commit tran
/* end */