if you want to do it in sql, you need to use dynamic sql
declare @r1 as varchar (5),@sql nvarchar(1000),@params nvarchar(500)
set @r1='Title'
set @params ='@r varchar(5)'
set @sql = 'select name as ' + @r1 + ' from customer'
EXEC sp_executesql @sql,@params,@r1
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Parameter as a header in select statement
Posted - 11/28/2011 : 03:41:24
