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
Conversion failed when converting date and/or time from character string.