How do I assign different weights to columns in SQL Server Full Text Search?

Posted by gcaprio on Stack Overflow See other posts from Stack Overflow or by gcaprio
Published on 2010-06-10T18:42:20Z Indexed on 2010/06/10 19:02 UTC
Read the original article Hit count: 233

Filed under:
|
|

I'm using SQL Server 2008 FTS and I'd like to be able to integrate weighted rankings into my search results. However, I'd like to weight the columns that a search term is found in differently. For example, if I have a Title column and a Description column, I want matches fond in Title to rank higher than matches in Description.

Is this possible in SQL Server 2008? As far as can I see, I can only add weights to specific terms, not column locations.

© Stack Overflow or respective owner

Related posts about sql

Related posts about full-text-search