Archives of the TeradataForum

Message Posted: Tue, 28 Oct 2003 @ 14:13:01 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Define the carriage return and line feed as this:

DECLARE NL CHAR(2) DEFAULT '0D0A'XC;

Then build your string using the NL variable.

Set MSG = 'abc' || NL || 'def' || NL;

	<Prev	Next>		<<First	<Prev	Next>	Last>>