Archives of the TeradataForum

Message Posted: Wed, 20 Nov 2002 @ 22:08:51 GMT

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

Unless you cast the final string into CHAR(xxxx), it'll be a VARCHAR, which will have indicator bits set - they're the unprintable characters.

so try

SEL A || '|' || B ||.......(CHAR(500)) as columname;

Sam

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