BLandry474 (10/21/2016)

---

Hanshi,

Thanks for your reply, but unfortunately its way over-complex. I found a way to do this that is simple and elegant.

1. Run SP_COLUMNS and direct output to a Temp table.

2. Take the output and hit the Temp Table to get just the Table and Columns I want.

3. Use that filtered output as the comparator against the client table and values I want to check.

Sweet, simple, easy and it works with just a few lines of code.

"A Backhoe is a powerful and capable machine, except when you are trying to plant a single flower. Don't use a backhoe when a small shovel will do better..."