How do I reference a new line in sql for my database mail query?

Hi,

I have written the attached database mail query but I'm struggling to find the sql to reference a new line in my query. In the attached code I have tried '\n' but it doesn't seem to work. Can anyone help?

DECLARE @trust_subject NVARCHAR(100)
DECLARE @trust_message NVARCHAR(MAX)
SET @trust_subject = 'Trust System - Crucial Date Alert';
 
DECLARE  CursorTemplate CURSOR 
      FAST_FORWARD FOR       
      Select 
      'This is a reminder that the below crucial date is due exactly two months today:\n\nClient Name: ' + tt.ClientName + '\n\nMatter Number:' + tt.MatterNo + '\n\nPartner:' + tpl.PartnerDescription + '\n\nFee Exec:' + tfel.FeeExecDescription + '\n\nDue Date:' + CAST(cdtcd.DueDate as NVARCHAR) + '\n\nEvent:' + cdel.EventDescription
      From Trusts.Trusts tt INNER JOIN Trusts.PartnerLookup tpl ON tt.PartnerCode = tpl.PartnerCode INNER JOIN Trusts.FeeExecLookup tfel ON tt.FeeExecCode = tfel.FeeExecCode INNER JOIN CrucialDates.TrustCrucialDates cdtcd ON tt.TrustID = cdtcd.TrustID INNER JOIN CrucialDates.EventLookup cdel ON cdtcd.EventCode = cdel.EventCode
 
OPEN CursorTemplate
 
FETCH NEXT FROM CursorTemplate 
INTO      @trust_message
 
WHILE (@@FETCH_STATUS = 0)
BEGIN
	EXEC msdb.dbo.sp_send_dbmail
      @recipients = 'someone@somewhere.co.uk', 
      @body = @trust_message,
      @subject = @trust_subject
 
      FETCH NEXT FROM CursorTemplate 
      INTO      @trust_message
 
END
 
CLOSE CursorTemplate
DEALLOCATE CursorTemplate

Select allOpen in new window