Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Tue, 05 Apr 2005 @ 12:54:22 GMT





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




Subj:   Re: How to simulate built in function RPAD of Oracle in Teradata
 
From:   Anomy Anom



<-- Anonymously Posted: Tuesday, April 05, 2005 08:49 -->

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



     substr( (your-column || 'xxxxxxxxxxxxxxxxxxxxxxxxxx'), required-length)




     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008