Posted by Simon Hayes on 09/27/55 11:16

"woody" <shellymatthys@yahoo.com> wrote in message
news:1116520901.938978.137540@z14g2000cwz.googlegroups.com...
>I was expecting results from a Contains clause to return better hits
> first. Am I off base?
>
> Example Table:
>
> Title
> -----
> red house
> green house
> red green house
>
> searching with Contains(' "red" or "green" or "house" '), I would
> expect the last row to show up first since it contains all three. Not
> the case.
>
> Is containstable the only way to get ranked results?
>
> All input is appreciated.
>

Books Online specifically says that if you require ranking, you should use
CONTAINSTABLE, so I would assume there's no (easy) way to do this with
CONTAINS. If this isn't helpful, you might try posting in
microsoft.public.sqlserver.fulltext - it would probably be useful to give
some extra details of what you're trying to do, why you don't want to use
CONTAINSTABLE etc.

Simon

• Next in forum: Re: Newbie: Transfering databases from different servers
• Prev in forum: Re: How to assign quota on a specific datafile?
• Thread view: Re: newbie: Can results from "Contains" be ranked?

[Reply to this message]