Apostrophes in Full Text Search

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramesh - 07 Sep 2007 20:23 GMT

I would like to search the words like O'Donnel, O'Connor,Steve's etc.. in the attachments. Tried to use ContainsTable and replaced the apostrophe with another before sending to the search engine.

Also i have to search Connor in O'connor

Any thoughts

From http://www.developmentnow.com/g/104_2007_6_0_0_0/sql-server-fulltext.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Reply to this Message

Hilary Cotter - 10 Sep 2007 16:01 GMT

All the interfaces I am aware of (except Query Analyzer) will double quote
them.

However you can also put a replace(@myString,char(39), char(39)+char(39) in
your tsql code before it hits the full-text index.

Signature

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

>I would like to search the words like O'Donnel, O'Connor,Steve's etc.. in
>the attachments. Tried to use ContainsTable and replaced the apostrophe
[quoted text clipped - 9 lines]
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com

Reply to this Message