Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 20:28:44 GMT

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

Hi,

try

     create table t01 ( text varchar(255) );
     insert into t01 values ( 'Hello' || '0D0A'xc || 'World !' );

'0D0A'xc is length 2

'0D'xc is length 1

Christian

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