Archives of the TeradataForum

Message Posted: Thu, 22 Mar 2012 @ 14:22:00 GMT

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

Try

     Select 'Line 1' || '0D0A'xc || 'Line 2'

This assumes you want a Windows line end.

If you just want a carriage control then use '0D'xc instead.

Mike Dempsey

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