Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-05-12 : 10:39:39
|
| Hi,Could you please modify this query so that I can update?Please note that the field Comments is a text field.I do know that I have to use updatetext but do not know how to.Thanksupdate tblnameset field1 = field1 + ' - hello there'where surname = 'johnson' |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-12 : 11:30:54
|
| Is there anything I can do to talk you out of text...What's the max length of the column?Do you know what books online is?Brett8-) |
 |
|
|
|
|
|
updatetext