Archives of the TeradataForum
Message Posted: Fri, 24 May 2002 @ 14:57:08 GMT
| Subj: || || Re: Format statement and floating point numbers |
| From: || || Michael McBride |
John, thanks for your input, the emplyee_nbr is stored in the database as a varchar(15) 'charcter string'. It is the required output
parameters that pose the problem. 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. I cannot change this requirement. To get the right justification, I cast the
internal character sting to a floating point number, it is the zero filling that I am having dificulty with...