CONTAINS simple terms search acting like prefix search.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sqldba - 21 Oct 2005 18:20 GMT

MSSQL 2000 sp3a, on Windows 2003.
I will use examples from BOL. I am searching with a CONTAINS like this:
WHERE CONTAINS(ProductName, ' "sasquatch ale" OR "steeleye stout" ')

and am receiving results like 'sasquatch's ale' and 'steeleye's stout'.
Plurals.

Strange. I have performed a full population and this continues to
happen.

Charlie

Reply to this Message

Hilary Cotter - 21 Oct 2005 19:18 GMT

Those aren't plurals - those are possessives.

Try "sasquatchs ale" OR "steeleyes stout"

> MSSQL 2000 sp3a, on Windows 2003.
> I will use examples from BOL. I am searching with a CONTAINS like this:
[quoted text clipped - 7 lines]
>
> Charlie

Reply to this Message

sqldba - 21 Oct 2005 19:31 GMT

Plurals - Possessives. Wither way I ask for the phrase "sasquatch ale"
and I get 'sasquatch's ale' . Why?

Reply to this Message

Charlie - 21 Oct 2005 20:01 GMT

Pardon the spelling the last message. I think I may have resolved the issue.
I changed from an English[United States] Language for Word Breaker to Neutral
and it seems to work now. Not sure if this is going to introduce any new
anomalies or not but.....we just testing now so bring them on.

> Plurals - Possessives. Wither way I ask for the phrase "sasquatch ale"
> and I get 'sasquatch's ale' . Why?

Reply to this Message