It's not clear how you determine which record would be the first one in the sort order.

>I need to sort out the records by similairity of 4 fields :
>
>eg.

>field1,field2,field3,field4
>
>1,2,3,4
>0,5,6,4
>5,3,4,2
>5,6,7,8

>
>
>
>so, the sort result sould be
>
>1,2,3,4
>5,3,4,2 Because 2,3,4 match 1st record, 3 similairity
>0,5,6,4 Because 5,4 match 2nd record
>5,6,7,8 because 5,6 match 3th record
>
>
>
>
>Anyone have solution for this.
>
>thanks.