-- READTEXT with a protected text pointer
 
BEGIN TRAN
DECLARE @mytextptr varbinary( 16 ), @sizeneeded int, @pat_offset int
SELECT @mytextptr=TEXTPTR(pr_info), 
    @pat_offset=PATINDEX('%Washington%',pr_info) -  1 ,
    @sizeneeded=DATALENGTH(pr_info) - 
        (PATINDEX('%Washington%',pr_info) -  1 )
    FROM pub_info (HOLDLOCK) WHERE pub_id='0877' 

IF @mytextptr IS NOT NULL AND @pat_offset >=  0  AND
    @sizeneeded IS NOT NULL
    READTEXT  pub_info.pr_info @mytextptr @pat_offset @sizeneeded

COMMIT TRAN