i want to get the record where column name equals to row record

above is the table and record i am using, in the below table i want to retrieve value 3 that is 11-20 column and row 11-20.

could any one he开发者_开发知识库lp me please.

Thanks,

Pradeep

---

SELECT [11-20] FROM ProductLines Where ProductLine='11-20'

---

SELECT 11-20 FROM tablename WHERE ProductLine = '11-20'