Post reply

Full text query

  • January 3, 2005 at 8:50 am

    #87255

    Does anybody know how to show the rank column of a full text query as number that an user can undersntand (i.e it can be showed as a percentage number)

  • January 4, 2005 at 1:16 am

    #535713

    SQL Server 2000 Books Online (BOL) title "Full-text Search Recommendations, states relative to RANK that "...RANK values returned in the result set are relative to each other. Therefore, it is not possible to interpret the RANK value as a percentage or group the RANK values into high/medium/low ranges. Think of RANK as a method to order the results for a specific query and result set".

    That said, could you provide a more detailed example of what your user would want? As the results are query specific, would (s)he want to see the top rated row have a value of 100 and the bottom row have a rank value of 0? How about ties or mutiple rows having the same query specific rank values? Would your searcher be willing to limit the total number of rows returned (even if more rows would qualify) to be able to do this type of calculation?

    Thanks,

    John

    SQL Full Text Search Blog

    http://spaces.msn.com/members/jtkane/


    John T. Kane

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply