Re: search with hyphen

Tech-Archive recommends: Fix windows errors by optimizing your registry

This is the default behavior for the French Word breaker. One of the French
Language rules is that if the tokens are capitalized and there is a hypen
between the words, the words are treated as one word. I take it you are
using French.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"nick via SQLMonster.com" <forum@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eb8709982f6145f5bd39b5a846c166b8@xxxxxxxxxxxxxxxxx
> Hi, I'm verry new in the world of full text index and I got some problem
> with my search engine when a hyphen is envolved. For example :
>
> I've got "Casse-croûte" in my table under the column name_org.
> When I search for "Casse-Croûte", it find it.
> But when I search for "Casse-CROûte" or "cASSE-croûte", it don't find it.
> If I search for "CROûte" or "croûTE", it will find it.
>
> It seem is not case sensitive when only the two first letter is in Upper
> case when a hyphen is envolved. So if the second letter or the third
> letter hare in upper case it don't find it.
>
> this is my @@version :
>
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
>
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
>
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
>
> and this is my OS :
>
> Microsoft windows 2000
> 5.00.2195
> service pack 4
>
> and this is my code in my stored proc :
>
> Set @WhereName = ' contains(oo.u_Namestrip, ''formsof(inflectional, "'
> +@WhereName + ''')'
>
> thank you in advance...


.