I'm using Full Text Search like this:
WHERE FREETEXT(*, @Words)
Example: where @Words = "Blue Baby Wrist Bracelet"
I search the Name and Description columns of the table.
But when I do a search for the above example, which is in the product Name column,
that product does not come up first in the list. The products that show up first
are the ones with "Baby" in the Description column, ex:
"Baby Oval Stripe Top Baptismal Pin. 22KT Gold over Sterling Silver"
Then "Blue Baby Wrist Bracelet" shows up at 30 on the list.
Is there a way to get the search to list the items FIRST that have all the keywords
in the search. Like in the above example, I would want "Blue Baby Wrist Bracelet"
to be at the top of the search list.