New line in concatenated field
I have a query which populates a field by concatenating few other fields. For each field concatenated, the value should be displayed in a new line.
SELECT 'INSERT INTO Table1(
(''Name: ' + ForeName + ' Surname: ' + SurName + ' Title: ' + Title +);'
INSERT INTO Table1 (title) values (Name: XX SurName: YY Title: ZZ)
Is there a way enough space is created between each concatenated field so that they get displayed in new lines
rather than Name: XX SurName: YY Title: ZZ
Char (13) does not seem to help.