On 7/16/2004 at 12:14 PM frische_brise2003 wrote:

> 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
>

MY_TEXT = 'Hello' || '\x0d\x0a' || 'world';

or simply MY_TEXT = 'Hello\x0d\x0aworld';

HTH,

Dan.