sql server full text search: Apostrophes in Full Text Search -- sql server full text search

Apostrophes in Full Text Search

Ramesh
9/7/2007 12:23:22 PM

sql server full text search: 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.htm

Posted via DevelopmentNow.com Groups

Re: Apostrophes in Full Text Search

Hilary Cotter
9/10/2007 11:01:32 AM

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.

--
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
[quoted text, click to view]