CREATE PROCEDURE COLUMNRETURN
@ColumnName as nvarchar(100)
as
declare @sql as nvarchar(max)
set @sql = 'Select [' + @ColumnName + '] from [mytable]'
exec (@sql)

EXEC COLUMNRETURN 'mycolumn'