I bet Sergey can figure out a way to do this!

If I have the following SQL statement, it works fine:

SELECT CodesKey AS 'codesdeptkey', * from codes

I'd like to parameterize this, but if I try this it gives an incorrect syntax error:

DECLARE @KeyName varchar(50)
SET @KeyName = 'codesdeptkey'
SELECT CodesKey AS @KeyName, * from codes

Any ideas??? (other than obvious setting a string to the whole SELECT string and then EXECing that ... the SELECT string is obviously more complicated than what I've indicated above).

TIA,
~~Bonnie