New line character passed through SQL

Hi,

I was hoping someone could explain how to pass a newline character in the SQL msg. I tried '\n', '/n' etc. but it is not passing through to Slack. How to do create a new paragraph in my message?

Thanks,
Testerman

[devlead]

You should be able to just do a line break like

SELECT N'Line 1
Line 2'