Split multiple columns into single column by delimiter?

Question

split multiple columns into single column by delimiter?

srinivas P · Answer

Name Address Srini vasa rao 103 guntur kothapet Naresh babu Ongole pandaripuram Chenna reddy Narasarao pet I want to show following way from above two tables separated by delimeter 'space' srini vasa rao naresh babu Chenna reddy 103 guntur kothapet Ongole pandaripuram Narasarao pet The above task will do in sqlserver

srinivas P · Answer

Name Address Srini vasa rao 103 guntur kothapet Naresh babu Ongole pandaripuram Chenna reddy Narasarao pet I want to show following way from above two tables separated by delimeter 'space' srini vasa rao naresh babu Chenna reddy 103 guntur kothapet Ongole pandaripuram Narasarao pet The above task will do in sqlserver

Muralidharan Deenathayalan · Answer

Is it part of the same select statement ? Please explain more.

Amit Choudhary · Answer

do you have a column collection delimited by some special symbol? or you want to merge the different columns into one separated by some delimiter. You question is not clear. please provide little more brief.