>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

Unfortunately you should use so called Dynamic SQL for this:

DECLARE @KeyName varchar(50)
SET @KeyName = 'codesdeptkey'
DECLARE @sql nvarchar(max) -- for SQL 2005 or 2008 (or (4000) for 2000)
SET @sql = 'SELECT CodesKey AS '+ @KeyName + ', * from codes'
EXEC (@sql)
--- If @sql is larger than 4000 chars you should use this:
--- EXEC sp_executesql @sql