Archives of the TeradataForum

Message Posted: Thu, 15 Jun 2006 @ 15:04:31 GMT

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

I am trying to induce the Format Query command to induce a newline after a comma.

With this capability a "before" query that looked like this:

     Select MyColumn1, MyColumn2, MyColumn3
        From Junk Order By MyColumn1, MyColumn2

Would look like this:

     Select
        MyColumn1,
        MyColumn2,
        MyColumn3
     >From Junk
     Order By
        MyColumn1,
        MyColumn2

I know Keyword.txt works on words like CASE, CREATE, SELECT, etc, but is there a way to make

     , 0

Work?

Cheers,

Jack Howard

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