>Have a two dimensional array. Want to scatter into the columns of row 1. Have tried several ways but it seems to scatter into (row1,column1), then (row2,column1), etc.
>
>Anyone know how I can scatter/gather into a two dimensional array?
>
>Thanks Brenda

Brenda,

It just occurred to me while I was getting a coffee - SELECT * FROM tablename INTO ARRAY arrayname - see the help on SELECT - SQL (not just select).