Archives of the TeradataForum

Message Posted: Mon, 06 Oct 2008 @ 15:55:37 GMT

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

Hi,

How to concatenate NULL values with other values from query?

The example below doesn't work; I'm getting only '?' value in FSAMPLE.txt.

     ---------------------------

     .export reset
     .export report file = FSAMPLE.txt
     .set FORMAT OFF
     .set WIDTH 200
     .set NULL AS '.'

     SELECT
        'A'||';'||'A'||';'||'A'||';'||NULL||';'||'A'||';'||'A'||';'||'A'||';'||'A'||';'||'A'||';'||'A'||';'||'A'(TITLE '')
        ;

     .export reset

     .quit

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