That is huge understatement. It is nowhere near good practice to store column headers in the table. :w00t:

Bad practice aside you can accomplish with dynamic sql.

Let's start with some ddl and sample data in a consumable format (this is a good habit for your future posts). Then we can proceed with the kludge to pull this off.

create table #Other

(

Other varchar(25),

OtherText varchar(25)

)

insert #Other

select 'X', 'Football'

declare @ColHeading varchar(50)

select @ColHeading = 'Other (describe):' + OtherText

from #Other

declare @sql nvarchar(max)

set @sql = 'select Other as [' + @ColHeading + '] from #Other'

exec sp_executesql @sql

drop table #Other

Hopefully that is something that can at least get you started to make this work.