Well that little recommendation is worth a million bucks! Appears to be as fast as running the SELECT statement. Thanks:)

I guess I hadn't thought of that. I actually try to stay away from dynamic sql. I always thought there where sql injection issues with it. Only use it if its really necessary. This may qualify.

Wouldn't the User still need Select permissions on the tables?

Patrick