No, you cannot generally variablize column names, Dynamic SQL is how to do this.

There are some limited ways around it for specific cases, using if statements or other high-level branch techniques to select different queries based on the variable, but they're more trouble than they're worth once it goes beyond more than a couple of choices.

If you do use Dynamic SQL for this, however, you need to make sure that it's protected against SQL Injection.