Need to Merge text in a cell

• jeganbenitto.francis

  SSC Eights!

  Points: 956

  More actions

  December 24, 2013 at 12:15 am

  #301644

  HI ,

  If i have a value as AAA,AAA,AAA,AAA,BBB,CCC

  Then i want return it as AAA,BBB,CCC. Can Anyone please suggest whether this is possible.

  Thanks in Advance

• igorgorb

  SSC Rookie

  Points: 32

  More actions

  December 25, 2013 at 5:49 am

  #1675880

  Hi,

  http://www.sommarskog.se/arrays-in-sql.html or https://www.simple-talk.com/sql/t-sql-programming/faking-arrays-in-transact-sql/ or http://www.sqlservercentral.com/articles/T-SQL/63003/

• LutzM

  SSC Guru

  Points: 107049

  More actions

  December 28, 2013 at 5:27 am

  #1676209

  You could split the string using the Delimited Split Function refernced in my signature and the "FOR XML PATH" approach together with a DISTINCT to build te final string.

  If the length of each element is known and constant, the split function can be simplified.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]