I have a value which I don't know which column this belongs to in the table. So is there a way I get get those rows that contain this value using query?


How many columns are we talking about here?

I have managed to get the row needed with a value in a known field, into a data row. In this datarow, taken from the main table, I now have to search for another value and get it's column name. There are 37 columns in this table from where I have retrieved the datarow.


Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.