Hi,

I've got a table with a large amount of columns, and would like to be able to return all those rows which match a given percentage (call it 70%) of a query. So lets say I have a table with 10 columns A, B, C, D ,E, F, G, H, I, J.

And let's say I query on all 10 columns. What I would be actually looking for is all rows where ANY 7 columns match. Obviously this can be done by amalgamating a large amount (10C7 is 120, 10C8 is 45, 10C9 is 10) of ANDed select queries via OR. Is there a better way?

Any help would be appreciated.