Thanks for your response. This particular bit of dynamic sql code was part of a much bigger part of dynamic sql infested code. I was able to get rid of the rest of the dynamic sql logic except this.

This has made the code I am working on much easier to read and comprehend.

Oh well, I guess I will have to live with this one bit of dynamic sql code!