I realize this is several years later, but I'm also looking for a solution. But the solution provided here gets the names of columns that have a value in the name of the column, not within the data. I think the original question was looking for code that would return any column name of a table where the column's data contains a specified value. I could be misinterpreting though, so forgive me if that's the case. But regardless, I'd like to know the answer to what I interpreted the question to be. I've found plenty of code that shows how to return a the name of the column if that column name contains a specific value, but nothing to return a column name if that field contains a specific value.