Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Question Unanswered: How to Merge data of type TEXT

    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:

  2. #2
    Join Date
    May 2011
    Posts
    28
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •