>>>>> Roberto Della Pasqua l'ha dit:

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

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

I think that's impossible without the help of a stored procedure. Such
SP could do a SELECT ... WHERE <allfields>, a SUSPEND then another
SELECT on two fields followed by a SUSPEND, and so on.

hth, ciao,
lele.
--
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.