Archives of the TeradataForum

Message Posted: Wed, 06 Oct 2004 @ 12:15:26 GMT

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

Does SQL have the potential to wrap text - instead of relying on a client utilities command like '.FOLDLINE' (From BTEQ) to achieve this wrapping of text.

i.e. if I were to give a SELECT statement selecting a character data type column which contains a string say > 80 (> default width specified by BTEQ) - is there a possibility to wrap the text without using any BTEQ related command like FOLDLINE or WIDTH or exporting it to a file with a .EXPORT REPORTWIDE option.

Narayan

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