TEXT Data Type Column: Replacing Chars : Why Isn't This Routine Working?

Hi;

I am trying to write a rountine ( below ) that will go into a colum of
text data type ( fae.pmcommnt ) locate the word "to" and replace it.

I have the routine below. I get no error messages, but it also seems
to do nothing :).

Any clues would be greatly appreciated.

Thanks

Steve







================================================== =============
declare @ptrP int

SELECT @ptrP = PATINDEX('%to%', pmcommnt)from fae where projid =
'00013'

declare @ptrPC binary(16)
select @ptrPC = TEXTPTR(pmcommnt)
from fae

if( TEXTVALID ('fae.pmcommnt', @ptrPC ) > 0 )
print 'works'

print @ptrP

UPDATETEXT fae.pmcommnt @ptrPC @ptrP 2 'JJ'


select projid, pmcommnt from fae