SQL Server : return column names based on a record's value

Question

Hi,


I have one table.I want tha column names based on column values

 

|Field1 |Field2 |Field3 |Field4 |

|-------|-------|-      ------       |-------|

| 1      |  0      |    0       |1 |

 

 

now i want the field name contain zero.Is this POssible in sql server.

What I have tried:

I've been trying to do various joins against sys.columns (and sys.tables), but so far to little avail.