I always dimension the array just before issuing select... into array xArray, because when select returns 0 (zero) rows, if xArray is in scope and not empty it will NOT be redimensioned or overwritten.