Hi Bonnie,
Nope. I don't think it can be parametrized. You'll have to use dynamic SQL.
Can you post your actual query? Does it return a lot of records?
>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,
>~~
--sb--