Hard return in the insert statement

[Blu]

How can I insert the data that contain the line breaks or hard return ?

[davey23uk]

via what mechanism?

[gandolf989]

Originally posted by Blu
How can I insert the data that contain the line breaks or hard return ?

You can concatenate a CHR(10).

INSERT INTO blah ('blah blah blah blah blah blah ' || CHR(10) ||
                  'blah blah blah blah blah blah ' );

[Blu]

Thanks.