Thanks to The Dixie Flatline for his/her response. I implemented the solution using Dynamic SQL and it works just fine now.

Here is the solution that I wound up with:

DECLARE @TableCatalog...

That's what I figured. I was just hoping that there might be some nifty trick that would get around it. I have done some work with Dynamic SQL in SQL...