Hi all.

I'm modifying text in a a stored proc.

Adding text works fine:

DECLARE VARIABLE MY_TEXT VARCHAR(1000);
...
MY_TEXT = 'Hello';
MY_TEXT = MY_TEXT || ' world';

But how can I add a 'carriage return - line feed'?
The result should be:
Hello
world

Regards

Jürgen