Basically, you can only use variables in the WHERE clause. To do anything else requires Dynamic SQL. If you really need flexibility, you could submit the query ad-hoc.

Also take a look at sp_executesql

-Mike