No, you don't need to be a jerk about it. People make mistakes, I made a mistake. You cant tell me that you've never made a mistake before....

You dont need to be a jerk about it. I made a mistake. I guess that I'm not perfect like you.

Jeff Moden (1/17/2008)

---

jkurtis (1/17/2008)

---

theres a couple problems with...

yah i was afraid of that. Im afraid that with the data I need to loop through that would take a while. One text field has over 43000...

I've used both writetext and updatetext, however they expect a varchar value as the last parameter. What i really want to do is use updatetext, but instead of passing...

theres a couple problems with that.

The 1st is that I'm on SQL2000. The second is that in one of my text columns there are over 43000 charactors. So...

That works, however the main problem that i have, which I neglected to put in the original message, is that the data in my text fields is larger than 8000...

You can't use the + operator on text datatypes.

I know you can do it in ADO, and haven't found anything out there that says that you can do it in T-SQL.

yah, after i sent this post i realized that I can get my info that way.

In a generic sense (not pertaining to the original problem), is there a way to...