>Hi George,
>
>The table is short. About 200 records and won't grow very fast. I tested using COPY TO ARRAY and seems pretty quick, but I am open to SQL to fill the array. Would SQL automatically declare and size the array for me so I don't have to wory about the dimensions of the array or declaration?

Steve,

Yes it will. However, I always dimension the array (to one element) before issuing the SQL statement. This eliminates the erroneous compiler references that can be causing by later referencing the array.