Any Column Select

[shers]

Hi,

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?

Thanks

 

[jmcilhinney]

You'll have to include every column in the WHERE clause with an OR between each pair of criteria.

 

[shers]

There are 37 columns in the table.

 

[jmcilhinney]

Oh, why didn't you say so? In that case, you'll have to include every column in the WHERE clause with an OR between each pair of criteria

 

[Herman]

Or, depending on the size of the table, get the whole table in a dataview and search it.

You can also look here for a method better suited to regular use:

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm