kokok_kokok wrote:

> By the way, I solved the problem calculating the score in the inverse way, so now I can use "order by score, name". Now it works fine.

I think, at the end of the day, all that IS required most of the time IS
a little bit of 'lateral thinking'. All to often the discussion gets
bogged down on some technical point, when a simply reworking of the data
solves the problem ;)

In the past I've had some quite amazingly slow queries which with very
little effort have been tamed - but usually not until I've had input
from one of these lists :) OK it would be nice if the 'engine' was so
clever as to solve these problems, but often the human insight is the
only way forward.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php