Archives of the TeradataForum

Message Posted: Fri, 24 May 2002 @ 15:39:33 GMT

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

<-- 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.

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