Specify exact number in where clause list

Is there a way to specify an exact number of any combination in a list?

For example I would like to say something like:

select * from table_name
where match_item in ('one','two','three','four');

but I want to be able to say, "Where any three of the four are matched."
or "Where any two of the four are matched."

The key is that I have to be able to specify exactly how many matches; no more, no less.

Thanks Received on Wed Feb 06 2002 - 01:46:31 CET