How to insert new line in a SQL text message ?

[click_on_qlik]

Hi

In the data load editor I want to send a mail , and i want to add a \n (newline ) in the text field message,  but it does not work 

here is the code

SELECT status,
result
FROM SendEmail
WITH PROPERTIES (
to='$(Email)',
subject='Result monitoring',
message='The  app name is xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

NEWLINE

xxxxxxxxxxxxxxxxxxxxxxxx ',
html='true',
fromName='aaaaa',
fromEmail='bbbbbbbbbbbbbbbbbbbb',
cc='',
bcc=''
);

[Aasir]

CHAR(13) || CHAR(10) is used to represent a new line.

SELECT status,
result
FROM SendEmail
WITH PROPERTIES (
to='$(Email)',
subject='Result monitoring',
message='The app name is xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' || CHAR(13) || CHAR(10) ||
'xxxxxxxxxxxxxxxxxxxxxxxx',
html='true',
fromName='aaaaa',
fromEmail='bbbbbbbbbbbbbbbbbbbb',
cc='',
bcc=''
);