0

I have this code:

SELECT CAST(Numero as varchar(255)) + ';' as Result  FROM Acao

This code returns this:

enter image description here

I want to return a single line like this: "52;56;57;59", because I want to put this in a formula of a computed column. How do I do this using SQL?

alansiqueira27
  • 8,129
  • 15
  • 67
  • 111
  • which RDBMS are you using? – StevieG Jun 25 '14 at 13:47
  • SELECT ( STUFF ( ( SELECT ';' + CAST(Numero AS varchar(255)) + CHAR(10) FROM Acao ORDER BY BE_ID FOR XML PATH, TYPE ).value('.[1]', 'nvarchar(MAX)') , 1, 1, '' ) ) AS XmlDecodedStuffInsteadSubstring – Stefan Steiger Jun 25 '14 at 14:00

0 Answers0