Question: Here is the sample
![See Sample](https://i.stack.imgur.com/VUGo3.png)

How to get this data based on day name from my table?

Answer: 
As mentioned by Larnu & GMB, you should consider fixing your design. For time being, you can also use Dynamic SQL.

```
DECLARE @sqlCommand VARCHAR(max);

SET @sqlCommand = 'SELECT DOCTOR_NAME FROM MY_TABLE 
                   WHERE ' + QUOTENAME(DATENAME(weekday, getdate())) + ' = 1';

EXEC (@sqlCommand)

```
The following query will help you to get result:

```
DECLARE @SqlQuery varchar(8000) 
DECLARE @DateVal DATE = GETDATE(), @DayName varchar(20)
SET @DayName = DATENAME(WEEKDAY, @DateVal);
SET @SqlQuery ='SELECT DOCTORNAME FROM TABLE_NAME WHERE '+ @DayName +'= 1'
EXEC(@SqlQuery)

```