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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-28 : 08:01:55
|
| Renato writes "Is it possible to update a text field with more information, like we can do with varchar fields in MSSQL Server 7 and/or MSSQL Server 2000.For example:If I have a table called "ABC" that have two fields "FL01" type "Varchar(12)" and another one "FL02" type "Text".To update the field "FL01" I can use:update ABC set FL01 = FL01 + 'test'but the same doesn't work for the other field:update ABC set FL02 = FL02 + 'test'Is there another way for doing that update ?Thanks in advance,Renato" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-28 : 08:02:55
|
| Yes, there is a specific T-SQL command called (surprisingly) UPDATETEXT. The syntax and usage is different than a normal SQL statement, Books Online has examples of how it works. Be sure to look at READTEXT and UPDATETEXT as well. |
 |
|
|
|
|
|
Adding text to a text field