>Hi Kenneth,
>
>Frankly I think that David's solution is the most elegant, and probably more optimizable. Nonetheless I have something working along the lines of what you're trying to do, and that error used to crop up everytime the array was empty. So try to check that there is at least one element in there before you execute the SQL statement.
>
>Good luck.
>
>Matt

Thanks for the information Matt. I actually did use David's solution (with pinch of Ed's code -- GROUP BY ) because, as you noted, it is more elegant. I'll play with my old code at some point just to try to figure out why what was happening happened. As I recall, the code would not even be put into the macro expand string unless there was at least one element in the array but I could be mistaken. Definitly wouldn't be the first time!

Thanks again,