Re: assigning weight to columns with fulltext (is it possible?)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

PS. I did have something going a while ago where I used CONTAINSTABLE
and severals join plus some variables which contained the weight and
used that on the RANK value. Thing was, it was REALLY really slow on
10,000+ records.

On Dec 13, 7:09 pm, Pacific Fox - Web Design Brisbane
<tacofl...@xxxxxxxxx> wrote:
Hello all,

I have a table which has several fulltext enabled columns.

Title, Summary, Description

I was wondering whether it is possible to assign some kind of weight
to the columns? For example, I find it more relevant if the keywords
are in the title than in the description. Therefore I would like
records that have the matching keywords in the title to come up first.
I'm thinking the way to achieve this is by assigning weight to the
columns, but am not sure how to go about doing this.

Any advice is much appreciated.

.

Relevant Pages

  • Re: assigning weight to columns with fulltext (is it possible?)
    ... Looking for a SQL Server replication book? ... I was wondering whether it is possible to assign some kind of weight ... records that have the matching keywords in the title to come up first. ...
    (microsoft.public.sqlserver.fulltext)
  • assigning weight to columns with fulltext (is it possible?)
    ... I have a table which has several fulltext enabled columns. ... I was wondering whether it is possible to assign some kind of weight ... records that have the matching keywords in the title to come up first. ... Any advice is much appreciated. ...
    (microsoft.public.sqlserver.fulltext)