Archives of the TeradataForum
Message Posted: Fri, 24 May 2002 @ 15:39:33 GMT
| Subj: || || Re: Format statement and floating point numbers |
| From: || || Anomy Anom |
<-- Anonymously Posted: Friday, May 24, 2002 11:16 -->
If your output was char(20) (right-justified, left padded with zeroes), would the application able to handle the conversion from char(20)
to a numeric field with 20 positions? Apparently in that application that size of field is valid, so there must be some type command to
convert from char to numeric.
This seems like bad design me. I would never define a static field, such as employee number, as a numeric.