You'll need to work with using dynamic SQL to make that work properly. But beware, there are some things to consider when working with dynamic SQL. Here's a good read on the topic.
http://www.sommarskog.se/dynamic_sql.html
John Rowan
======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden