Select Statement to return single string of rows

[ousoonerjoe]

Have you looked at REPLACE()?

SELECT [Names] = AccountName,
	[Addresses] = AccountAddress,
	[Display] = AccountName + ' ' + REPLACE(REPLACE(AccountAddress, CHAR(13), ''), CHAR(10), '')
FROM tblAccounts;

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------

 

[edmana]

The select statement you wrote returns 3 columns.

I need a single column returned with 1 value which is the concatenation of the rows.

 

[ousoonerjoe]

Remove the columns you don't need. I only did that so you could see the original data and the formatted data side-by-side. [Display] is the formatted result.

Be sure to heed George's warning about string lengths. They can get ugly quickly if you're not careful.

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------