Archives of the TeradataForum

Message Posted: Tue, 05 Apr 2005 @ 07:48:46 GMT

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

Hi,

How to format data to pad a particular column with certain character ?

     e.g. 109  ==> 109XXX
          2091 ==> 2091XX

In oracle, we can do it by RPAD (column, 6, 'X').

Regards,

Shaju.

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