Limit Size of Calculated Field

[PGMR1998]

I am creating a file from SQL code,and I am creating a new field in the file using the sum parameter. But the sum field size after I run the code is much larger than I need or want. How can I set its field size?
The resulting field is too large, about size of packed 30. I need only PACKED 10. I also do not need a packed field, but integer.

 

[PHV]

Use the CAST operator.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PGMR1998]

That worked! Thanks! Here is what I had to do to change the field from a PACKED 31 into a decimal 10.2 defined field:

CAST( sum(field name) AS decimal(10,2))