Subject adding a crlf in a stored proc
Author frische_brise2003
Hi all.

I'm modifying text in a a stored proc using a BLOB variable.

Adding text works fine:

DECLARE VARIABLE MY_TEXT BLOB sub_type 1 segment size 1024;
...
MY_TEXT = 'Hello';
MY_TEXT = MY_TEXT || ' world';

But how can I add a 'carriage return - line feed'?

Regards

J├╝rgen