Erland,

Thank you very much. This solved my problem and works on the ACTUAL query I am using and not just the simple version posted on the forum.

Also, I cannot tell you how many times I have visited (and printed) the article 'The curse and blessings of dynamic SQL' over the last couple of years! Thank you for your effort in writing the article. It has served me well. Obviously I need to visit it a little more. 😉

Rebecca