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 |
|
ronmc
Starting Member
12 Posts |
 Posted - 2005-07-25 : 09:47:02
|
| Does anyone know how I can add character text to a "text" field? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
ronmc
Starting Member
12 Posts |
Posted - 2005-07-25 : 10:43:11
|
| I was hoping to avoid using any stored procedures. It seems very easy to concatenate characters on to a varchar field. But it seems difficult to do the same type of thing to a "text" field. I am really looking to use some sort of select or update statement to append a block of characters to a "text" field.The reference you gave me was about the same conclusion I came to. You must use some sort of pointer to the "text" field, and then update it. That seems quite a bit more difficult than just appending the text to the field.Thanks. |
 |
|
|
|
|
|
Appending charcters to a text field.