Archives of the TeradataForum

Message Posted: Wed, 29 Jan 2003 @ 23:13:12 GMT

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

Is this what you are asking to do:

SEL  EMP_NO||'~'||
     trim(EMP_NAME)||'~'||
     EMP_AGE||'~'||
     EMP_DOB||'~'||
     trim(EMP_ADDRES)||'~'||
     EMP_STATUS||'~'|| as OneBigColumn
FROM EMPLOYE
;

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