I use clipboard viewer to see the actual characters (and codes).
Like the following shows the text I copied ends with
<CR><LF><sp><sp><sp><TAB><sp><CR><LF>
In my SysTasks dashboard, I have an erp-text-area that i am populating from a BAQ, with a calculated field that includes line breaks. All working well using CHAR(13) + CHAR(10):
(CAST(STRING_AGG(SysTaskParam.ParamName + ': ' +
(CASE SysTaskParam.ParamDataType
WHEN 'String' THEN SysTaskParam.ParamCharacter
WHEN 'Character' THEN SysTaskParam.ParamCharacter
WHEN 'Int32' THEN CAST(SysTaskParam.ParamInteger AS NVARCHAR(MAX))
WHEN 'Boolean' THEN CAST(SysTaskParam.ParamLogical AS NVARCHAR(MAX))
WHEN 'DateTime' THEN FORMAT(SysTaskParam.ParamDate, 'yyyy-MM-dd hh:mm:ss tt')
WHEN 'Decimal' THEN CAST(SysTaskParam.ParamDecimal AS NVARCHAR(MAX))
WHEN 'Long' THEN CAST(SysTaskParam.ParamLong AS NVARCHAR(MAX))
WHEN 'Token' THEN SysTaskParam.ParamToken
WHEN '' THEN SysTaskParam.ParamCharacter
ELSE 'No ParamDataType - could not display data'
END)
, CHAR(13) + CHAR(10) ) AS NVARCHAR(MAX))) as [Calculated_Params]