| Author |
CONTAINS simple terms search acting like prefix search.
|
|
| sqldba 2005-10-27, 7:55 am |
| 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
| |
| Hilary Cotter 2005-10-27, 7:55 am |
| Those aren't plurals - those are possessives.
Try "sasquatchs ale" OR "steeleyes stout"
"sqldba" <sqldba@comcast.net> wrote in message
news:1129915220.977952.192440@f14g2000cwb.googlegroups.com...
> 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
>
| |
| sqldba 2005-10-27, 7:55 am |
| Plurals - Possessives. Wither way I ask for the phrase "sasquatch ale"
and I get 'sasquatch's ale' . Why?
| |
| Charlie 2005-10-27, 7:55 am |
| 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.
"sqldba" wrote:
> Plurals - Possessives. Wither way I ask for the phrase "sasquatch ale"
> and I get 'sasquatch's ale' . Why?
>
>
|
|
|
|