T1.Field1 has a numeric INTEGER data type with the default format ‘-(10)9’. The user has values such as 123456, with no values of over 999999. The values, defined as being in INTEGER format, are to be converted to CHAR(8).
The following example illustrates the Teradata syntax for performing this numeric-to-character conversion.
SELECT Field1(CHAR(8)) FROM T1;
returns ‘ 123’ for the value 123456, where the result includes 5 leading pad characters and truncates significant digits.