Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 27 Apr 2005 @ 12:08:03 GMT

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

Subj:   Re: Right Aligning Character Field
From:   Victor Sokovin

  We are using fastexport for extracting data, the requirement is that, for some character fields the data should be right aligned. Is there any way through which this can be achieved.  

Potentially, the formatting could be done with the FORMAT clause in the SELECT statement but I am not sure there is a way to right-justify CHAR fields (numbers would be easier).

If FORMAT is of no help, try to explicitly left-pad your CHAR fields in the SELECT statement using ideas in, say, this recent thread:

www.teradataforum.com/teradata/20050405_074846.htm .

They mostly discuss right-padding there but left-padding should be possible as well.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023