asked on
Concat into separate lines
I am using T-SQL and what I am trying to accomplish is concatenate three columns. But I would like each of the columns to start on a new line. The three columns I have are date,subject,text.
right now this is what I am using:
CONCAT('Date: ', Date, 'Subject: ',Subject, 'Text: ',Text ) As 'Timeline'
How can I modify this concat function to put the date on one line then subject on another line then text on another line?
thank you
right now this is what I am using:
CONCAT('Date: ', Date, 'Subject: ',Subject, 'Text: ',Text ) As 'Timeline'
How can I modify this concat function to put the date on one line then subject on another line then text on another line?
thank you
Microsoft SQL ServerSQL
Last Comment
Paul MacDonald
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thank you
It seems rather bizarre to me to do your own concatenation within a CONCAT function. Instead, just put the additional value to be concatenated as its own entry, like this:
CONCAT('Date: ', Date, CHAR(10), 'Subject: ',Subject, CHAR(10), 'Text: ',Text ) As 'Timeline'
The other reason for that is in case the value is NULL; if it is, and you do the concat yourself, the NULL value will wipe out the CHAR(10) (or CHAR(13), whichever).
CONCAT('Date: ', Date, CHAR(10), 'Subject: ',Subject, CHAR(10), 'Text: ',Text ) As 'Timeline'
The other reason for that is in case the value is NULL; if it is, and you do the concat yourself, the NULL value will wipe out the CHAR(10) (or CHAR(13), whichever).
Thanks for the tip Scott. What DBA skills I have are self-taught and - while I probably would have come around to that answer in a few years - I appreciate your pointing it out.
Conversion failed when converting date and/or time from character string.