Hi,
I have a form where a user is allowed to select 4 criteria and then a result is obtained have the most matching records in the 1st rank and then the others.
For instance, if the user selects criteria A, B, C and D, the result obtained must be obtained having A, B, C and D 1st and then A, B and C and then A, B and D and so on...
Could you please help me having the code for this sql ?
If not, is there any script which does these types of search ?
Regards,
shailen
