hello kind users,

really I lack of a strong SQL knowledge, so please can somebody can help me? I need to achieve this, imagine:

select first 10 from maintable where field1=X OR field2=X OR field3=X

I like to have the select list ordered by the records that have big matching,
so as example the first record will be the record that has both field1,field2 and field3 mathching,
the second record will be a record with only two field matching... and so one.

Please forgive my bad english.

Kind regards and really thanks,

Roberto.

[Non-text portions of this message have been removed]