Re: Fulltext Contains Problem   

r.e.m. is indexed as r e m if r, e, and m are not in your noise word list.

R.E.M. is indexed as R.E.M and REM.

-- 
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
"Patrick"  wrote in message 
news:eP$FjMYCIHA.1168@TK2MSFTNGP02.phx.gbl...
> Hi
>
> I have a database containing artist names. When I try to do the fulltext, 
> with artists having DOT's in the name, I can't find those. Example, if I 
> search for "r.e.m" I won't get any results with
>
> select * from artists where contains(artistname,'r.e.m')
>
> if I do
>
> select * from artists where artistname='r.e.m' i get the results back.
>
> While reading on the web, I found out that some just use another column, 
> where they store rDOTeDOTm and when searching they replace the dot's with 
> "DOT". Anyway, this means that I have to index more data, which I really 
> don't like. So is there a "clean" way to solve this issue?
>
> Thanks
> Patrick
>

date: Mon, 8 Oct 2007 08:31:10 -0400   author:   Hilary Cotter