combine multiple lines into a single line in a column

Question

combine multiple lines into a single line in a column

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Use the REPLACE function. You'll need to work out what character is being used for line breaks - CHAR(13) or CHAR(10), maybe.

REPLACE(MyCol,CHAR(13),'||')

John

Nomvula Hall of Fame Points: 3778 More actions · Answer 2

Nomvula

Hall of Fame

Points: 3778

October 18, 2017 at 8:46 am

#1964228

Thank John
it did work.

Avi1 SSCrazy Points: 2323 More actions · Answer 3

John Mitchell-245523 - Wednesday, October 18, 2017 7:03 AM
Use the REPLACE function. You'll need to work out what character is being used for line breaks - CHAR(13) or CHAR(10), maybe.
REPLACE(MyCol,CHAR(13),'||')
John

nText columns can't be used in REPLACE function, may need to use Cast to varchar or nvarchar. But if size will be more than 4000 for nvarchar or 8000 for varchar than also it these string manipulation functions will not work.