Can you concatenate text datatypes???

[vic]

I would like to concatenate text datatypes. Is this possible??
I'm using field1 + " " + field2
I cannot convert to varchar since the size is larger than 8000.

Thanks, Vic

[GreatInca]

This will concatinate them for you, 8000 characters at a time. + don't work with text/ntext. If you need to put it in variables, you'll have to put each 8000 characters in a separate variable.

Convert(VarChar(8000), SubString(LongDescription, 1, 8000)) + Convert(VarChar(8000), SubString(LongDescription, 8001, 8000))

Text is a problemsome datatype as the data is stored elsewhere from the table. If your field fits in 8000 characters (or 4000 for unicode), ship it off to another table as a varchar field and link it as 1-1, sharing primary keys (you should try to keep row sizes as small as possible, definitly under 1000, preferably under 250).

------------
vic at 9/8/00 2:02:33 PM


I would like to concatenate text datatypes. Is this possible??
I'm using field1 + " " + field2
I cannot convert to varchar since the size is larger than 8000.

Thanks, Vic