Limit Size of Calculated Field
Limit Size of Calculated Field
(OP)
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.
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.
RE: Limit Size of Calculated Field
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Limit Size of Calculated Field
CAST( sum(field name) AS decimal(10,2))