Hello am trying to send an email which the body contains 2 lines using the following but am getting error message.
EXEC msdb.dbo.sp_send_dbmail @profile_name='ProfileNameHere',
@recipients = 'RecipientHere@hotmail.com',
@body = 'Line 1 here.' + CHAR(13) + CHAR(10) + 'Line 2 here.',
@subject = 'Subject Here'
Incorrect syntax near '+'.
What am I doing wrong or how can I achieve my 2 lines body email?
Thanks in advance.