In Sybase, I need to merge the data from all the rows of a specific column, which is of type TEXT. I mean combine all the values from TEXT type column to a single value of TEXT type.
Is there a way to achieve it?

Thanks
Arun:

Hi,
Typical string concatenation operator '+' is not applicable for text/image datatype. So, the answer is there is no direct way. Alternative way to take the columns in output then use awk/sed/perl to concatenate these two columns with text data type.
Please let me know if you find any sybase function or alternative way to do.