How to get a column's value, which stored in variable @col 1

[znet]

Hello, All
I get the column names of a table, using system table/system stored procedure. Now the column name(for ex, 'ExtraField', but actually unknown) stored in @col, I need check its value, but 'select @col' not work, it just show ExtraField. Anybody give me direction. Thanks

 

[rac2]

Try this

EXECUTE( "select " + @col + " FROM aTable WHERE whatever" )

 

[NoCoolHandle]

If I am reading you correctly you want to dynamicly add columns to the select statement..

This cant be done without dynamic execution..

i.e.

(important stuff in red)

-- This works...
Declare @col varchar(300)
select @col = 'orderid'
[red]exec ('[/red]select [red]' + @col + '[/red] from northwind.dbo.orders[red]')[/red]
go
-- THis doesn't
Declare @col varchar(300)
select @col = 'orderid'
select @col from northwind.dbo.orders

 

[znet]

Thanks friends.
Your solutions work fine. Thanks