how to copy text data from one column to another

EXEC sp_dboption 'database name', 'select into/bulkcopy', 'true'

GO

DECLARE @textData varchar(8000)

select @textData = textData from table where id = 5

print '@textData'

print @textData

DECLARE @ptrvalDest binary(16)

SELECT @ptrvalDest = TEXTPTR(xsl)

FROM table WHERE id = 6

WRITETEXT table.textData @ptrvalDest @textData

GO

EXEC sp_dboption 'database name', 'select into/bulkcopy', 'false'

GO