Archives of the TeradataForum

Message Posted: Wed, 08 Dec 2004 @ 09:48:11 GMT

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

<-- Anonymously Posted: Tuesday, December 07, 2004 21:13 -->

Hi,

I have a BTEQ export which output something like this (the '0D0A'xc is the newline character):

     sel 'first'|| ''0D0A'xc || 'second';

I want the result to be:

     first
     second

and not --> first second. Is that possible?

Thank you.

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