Posted by Zamdrist on 06/11/07 20:20

I need to update/change the text in a table column of data type TEXT.
It's a smaller set of records (72) where I need to append onto the end
a string of text, the same for all records.

I don't quite understand how UPDATETEXT and WRITETEXT work, but here
is how I would write the Update query were the field not a TEXT type.

Update Matters Set Description = Description + ' (Stylized)'
>From Matters
Inner Join cwconnect On cwconnect.mmatter = matters.matterid

Thoughts how I might do this using WRITETEXT or UPDATETEXT?

Thanks,

Steve

[Back to original message]