Re: String concatenation limits...?

From: "Paul Harman" <paul@kasterborus.demon.co.uk> > >Now whenever I try to call this procedure, no matter how small the actual >values are for "comment" and "value", I get: > > 881: Resulting string length must be less than or equal to 255.> >Is string concatenation limited to 255 characters, or something? I didn't >have any problems before when my strings were all varchar(255)s but now >I've >gone up to the 4K an 8K strings it's just not having any of it. I think the clue is in the words: "Resulting string length must be less than or equal to 255." :-) I'm not sure, I *think* you can do the append in an update, something like UPDATE table SET column = column || othervalue BLAH, BLAH, BLAH... *might* work. But that's just a guess. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:88jd89$oku$1@news.xmission.com... > I think the clue is in the words: "Resulting string length must be less > than or equal to 255." :-) Yes, but... having looked that error message up via finderr I find that's to do with calling TRIM() on a string. I'm concatenating some CHARs together into a larger CHAR. Why the error? I've just gone through and peppered my SPs with TRACEs. It's definately the concatenation that's throwing the error. > I'm not sure, I *think* you can do the append in an update, something like > > UPDATE table > SET column = column || othervalue > BLAH, BLAH, BLAH... > > *might* work. But that's just a guess. Hmmm, maybe. But I need to pass the result to another stored procedure, not insert it into a table directly :*( Thanks for the help so far, Paul