Thank you much.

Using the sp_executesql stored proc got me past my issues.  Thank you so much to everyone who responded.  Nate.

Thanks for all the help everyone, my client is having network issues currently, but as soon as they get them resolved I'll give the sp_executesql solution a try!