string concatenation using "text" data type

[ctwilliams]

I want to concatenate a text field with a varchar field. For example...

SELECT MyTextField + ' append some other text'
FROM MyTable

SQL Books Online says that the "+" (string concatenation) operator can be used with "any of the data types in the character and binary data type category, except the image, ntext, or text data types."

I tried CAST'ing the text field to a varchar type, but this causes the text to be truncated after a certain number of characters.

Is there some other way to do this?

 

[nigelrivett]

Create a temp table, use updatetext to concatenate and select from that.
You might be able to do a similar thing in a function but would be slower.

======================================
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.

 

[SQLSister]

Yep what nigel said makes sense to me.

Questions about posting. See faq183-874