dump one dimension from .GetRows

GetRows always returns a two dimensional array. In my case the I sometimes
redimension the second dimension and add additional values manually. I may
then need to sort it and remove duplicates. Is there a way to redimension
the array returned by GetRows and remove the first dimension keeping only
the second? Is copying the array values into a new array the only way? I
would rather not write a custom sort routine when the first dimension isn't
ever used.

thanks
LJB

ljb
Tue Jul 08 10:49:55 CDT 2003

Will answer my own question! They say that's bad.

I ended up making a copy of the array's second dimension values, sorting the
temporary single dimension array, and replacing the values back into the
original array. Redim Preserve only allows you to change the last dimension
so clearly that won't work for me.