 |
 |
Archives of the TeradataForum
Message Posted: Fri, 24 May 2002 @ 15:32:35 GMT
| Subj: | | Re: Format statement and floating point numbers |
| |
| From: | | Mark Landry |
| | The output specification for this particular application requires the various numbers to be output in a 20 byte field, right
justified and zero filled from the left. | |
select substr('00000000000000000000', char_length(emplyee_nbr)) || = emplyee_nbr
| |