newline - New Line character in SQLite concatenate

Question

I know that, in some Programming language, if you do something like:

'This is on first line 
 This is on second line'

Then it will display properly like this:

This is on first line
This is on second line

When I concatenate a string in a SQLite database

SELECT *, [FIELD1] || '
'  || [FIELD2] from TABLE

(where [FIELD1] = This is on first line [FIELD2] = This is on second line)

it displays as such:

This is on first line 
 This is on second line

Is there a reason that it isn't displaying the characters properly?

Answer 1

SQL has no backslash escapes.

You can generate a newline in a string by writing it directly in the query:

SELECT [Field1] || '
' || [Field2] FROM MyTable

or use a blob literal:

SELECT [Field1] || x'0a' || [Field2] FROM MyTable

or use the char function:

SELECT [Field1] || char(10) || [Field2] FROM MyTable