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 |
|
mfemenel
Professor Frink
1421 Posts |
 Posted - 2004-06-02 : 21:07:42
|
| I'm trying to append a value to the end of a text column. I've got it worked out to append to the start of the column using updatetext as shown below:updatetext #output.xmlstring @ptrval 0 0 @appendfrontWhat I'm trying to figure out is what the length in bytes of the text column is because the offset parameter of updatetext is looking for what the offset shoud be. If I know that I can use updatetext and finish up. I'm fishin' for answers so feel free to throw any other wild suggestions out.Mike"oh, that monkey is going to pay" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-06-02 : 21:10:07
|
| The Datalength() function will do this.Damian |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2004-06-02 : 21:11:42
|
| Dude, before I just liked you, now I love you man! I totally forgot about datalength. It's amazing what you can't do with text.Mike"oh, that monkey is going to pay" |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-02 : 22:26:44
|
| Just use null and it will append.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Length of a text variable