I have a table that has columns similar to the following:
What I am trying to do is write a query that will get the column name based on the value of the field. So for example, the my criteria is A Desc1 will be returned. If the criteria is not represented in any of the columns, the query will return nothing. Is this doable, and if so, can someone point me in the right direction?