|
|
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
Navigation:
[Reply to this message]
|