ntext problem

[liza02]

how to edit a row with a data type ntext using the sql server database?

[frozenmist]

Hi Liza,
Do you want to update a row?
Then why dont you use the update query.

Update <tablename> set <ntextcolumn>=< value> where <condition>

If what u meant was something else , please specify.

Cheers

[edukulla]

You can use "updatetext ".. Its syntax and use is as below. With updatetext you can update the ntext column partly unlike the typical "update" where it will update the column content entirely with new content
DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(pr_info )
FROM pub_info pr, publishers p
WHERE p.pub_id = pr.pub_id
AND p.pub_name = 'New Moon Books'
UPDATETEXT pub_info.pr_inf o @ptrval 88 1 'b'

Hope this helps..

Thanks!