How to Combine multiple column in a table and create separate Column in SQL

Asked Jun 08 '18 at 05:29

Active Jun 08 '18 at 08:15

Viewed 52 times

How to Combine multiple column in a table and create separate Column in SQL and insert a single pipe '|' between the data even though some column has empty field.

I have tried using concat but got multiple pipe if there is empty field

  select top 4 concat(code2_1,'|',code2_2,'|',Code2_3,'|',code2_4) from 
  Sourcesql

enter image description here

above is a table

for example 4 th row i need PT01|PT02|PT04

I didnt get the answer even i find like below query then how can my above query is duplicate

   SELECT 
STUFF(
 COALESCE('|' + code2_1, '') +COALESCE('|' +code2_2, '') +COALESCE('|'+ 
code2_3, '') +COALESCE('|'+ code2_4, ''),
1, 0, '') AS bar
 FROM Sourcesql

edited Jun 08 '18 at 08:15

asked Jun 08 '18 at 05:29

Which database are you using? – Tim Biegeleisen Jun 08 '18 at 05:30
MS SQL .. own working database – Jun 08 '18 at 05:31
I think the highest voted answer in the duplicate link covers your question exactly. – Tim Biegeleisen Jun 08 '18 at 05:32
i agree your statement but what if some one using old version of sql then concat_ws doesnot work , please get me compatible answer – Jun 08 '18 at 05:35
Check the highly voted answer in the duplicate link. If I were to answer, I would just be paraphrasing it. – Tim Biegeleisen Jun 08 '18 at 05:37

How to Combine multiple column in a table and create separate Column in SQL

0 Answers0