 |
 |
Archives of the TeradataForum
Message Posted: Wed, 27 Apr 2005 @ 12:08:03 GMT
| 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.
Regards,
Victor
| |
