Apostrophes in Full Text Search

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
http://www.developmentnow.com
.

Relevant Pages

  • Re: My Saddest Post Over?
    ... Robert, if you check you will find that if you include an apostrophe in an exact search,it doesn't match the word with the apostrophe in it, but it matches it O.K. if you do an ordinary keyword search, but then the query becomes too vague to be useful. ... The ROTFL! ... my test showed that it can take an hour and a half for a USENET post to be indexed by the search engine. ... Robert Henderson ...
    (uk.sport.cricket)
  • Re: Usage errors that irritate you the most?
    ... with no apostrophe is almost as common. ... it's a shame Google isn't run by people who have some ... Google certainly know how to design a search engine. ... So therefore they /don't/ know how to design a search engine. ...
    (alt.usage.english)
  • Re: Outlook 2003 Search folders
    ... An alternative zu Outlook's search engine would be ... http://www.lookeen.net/en/1,0/Home.html that searches in attachments ... MVP - MS Outlook ...
    (microsoft.public.outlook)
  • search through attachments
    ... Does any one know how to search through attachments with VB ... That I need to build a search engine to search all the emails with ... Prev by Date: ...
    (microsoft.public.vb.6.webdevelopment)