update image data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: juststarter (juststarter_at_discussions.microsoft.com)
Date: 09/30/04

Date: Thu, 30 Sep 2004 06:29:01 -0700

hello
i have 1 table which have an image column
Table1 (id1 int, imCol1 image)

i want to update the contents of a record with the ones of another record
this is what i do :

EXEC sp_dboption 'dbName, 'select into/bulkcopy', 'true'
DECLARE @ptrval binary(16),@ptrvalTarget binary(16)

SELECT @ptrval = TEXTPTR(imCol1)
FROM Table1
Where id= 1

SELECT @ptrvalTarget = TEXTPTR(imCol1)
FROM Table1
Where id = 2

WRITETEXT Table1.imCol1 @ptrvalTarget @ptrval

if imCol1 = 0x31 where id= 1 , why after the update
imCol1 = 0xF7FFDD3D000000002401000001000500
where id =2 ?

shouldn't it be 0x31 as well ?