> using sql server 2k
>
> I think I already know the answer, but ...
>
> Is there anyway to use WRITETEXT or UPDATETEXT in a set operation like the
> following which, of course, doesn't work.
>
> update dbo.mytbl
> set txtcol = WRITETEXT dbo.mytbl.txtcol TEXTPTR(txtcol) 'some new text for
> colID' + cast(colID as varchar)
>
> I know that I can simply SET the field as normal (and will probably end up
> doing that), but I would like to avoid logging if possible.