Archives of the TeradataForum

Message Posted: Tue, 05 Apr 2005 @ 12:21:44 GMT

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

Hi,

try

     select    columnname ||
     substr('XXXXXXXXXXXXXXXXXX',1,20-character_length(columnname))
     from table...
     ;

to simulate RPAD(columnname, 20, X)

Regards,

Dirk

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