sql server 2008 - How to use the column name for comparison against a parameter in SQL? -

sql server 2008 - How to use the column name for comparison against a parameter in SQL? -

what trying accomplish here pass in day of week parameter, holds value of current day(wednesday, etc), , compare against column names determine column used in clause.

so take columns sunday - saturday. in clause want compare column names parameter passed in , pull value match.

say table below called daytable

sunday mon tuesday quarta-feira th fri saturday 1 1 1 1 1 1 0 1 1 1 1 1 1 1 select * daytable columnname = @dayofweek

this i'm wanting accomplish if possible. looking @ columnproperty don't think that's need.

select case @dayofweek when 'sunday' sunday when 'monday' mon when 'tuesday' tuesday when 'wednesday' quarta-feira when 'thursday' th when 'friday' fri when 'saturday' saturday end todaysvalue daytable;

sql sql-server-2008