Mansfield (4/23/2013)
Text, ntext and image are special data types that does not support the normal string operators.If you want to concatenate, you'll need to cast each field into varchar or nvarchar first.
And they have all been deprecated. Please consider changing your base tables to (n)varchar(max).
Of course I doubt you really need varchar(max) here because varchar can hold up to 8,000 characters. You can figure out how long your real data is with
select max(len(cast(YourTextColumn as varchar(max)))) as MaxLen
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/