Is it possible to set the field lenght of a field when using the SQL Select command. What I need to do is insert 4 lines into a table based on existing values in the table and calculated values. The fourth line is the sum of the first three lines. Number of fields is dynamic so I am using macro substitution to create the lines. In the original table the format of the numeric fields is 12. When I do my Select commands I get different lengths for the fields. Is there any way around this?

I am thinking of using arrays. I there is an easy way to print the values of the arrays? How about adding them (short of the brute force method of a For loop).