Archives of the TeradataForum

Message Posted: Thu, 07 Aug 2008 @ 21:31:05 GMT

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

Try this:

     .SET FORMAT OFF
     .SET WIDTH 254
     .SET PAGELENGTH 120
     .SET RTITL ' '
     .EXPORT DIF FILE=report.xls

     Select Trim(FieldName) (Title 'whatever name you want') From  myTable;

     .export reset

Thanks,

Zdravko Sonje

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