We use MS SQL Server 2005 full-text search. Our stored procedure for the search accepts a parameter which is the search string the user submitted using our site's search page. We use CONTAINSTABLE and FREETEXTTABLE.
The problem is when the user submits a search string with an apostrophe in it (ex. Foster's).
A search for "Foster's" does return the record which has the entry "Foster's" and also all Foster (without the apostrophe ).
However, searching for "O'Connor" will return the "O'Connor" record only and not any other Connor.
My problem now is: How do I make the fisrt example to works like the second one? How can I make my full-text search support the apostrophe? If it is indeed not possible, can you provide a link to an article that concludes/proves that MS SQL Server 2005 full-text search does not support the apostrophe in the search string?