Archives of the TeradataForum

Message Posted: Wed, 19 Dec 2007 @ 20:02:18 GMT

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

You can use something like that:

     select
     substr('          ',1,level) || (description) as descr
     from
     table;

     Where:

     '          ': If your field is, for example, CHAR(10),
                   you must use 10 spaces.
     level: level field
     description: Descr field

Bye

Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina - Grupo D

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