TEXT concatenation

[Technokrat]

I need to concatenate a TEXT datatype field from several rows, into one resulting output, and its fine for the output to be varchar (8000). How do I go about this?

I've tried creating a cursor, but the problem is that it won't let me create a local var of type TEXT. I want to trancate my results after concatenation, not truncate each piece first, and then concatenate.

Any thoughts???

 

[Catadmin]

Try declaring several Varchar(xxx) variables, then do a cast/convert on the text datatypes when you're pulling them in. Such as Cast(<textfield> AS Varchar(xxx)). Then concatenate them into your variable that you already declared as Varchar(8000).



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!

 

[Technokrat]

The problem with your suggested method is that it truncates the pieces before concatenation. I want to truncate the result after all items have been concatenated.