Apostrophe (') in Full-Text Search String SQL server-2016
Posted on 2016-10-14
SELECT * FROM [dbo].[FTSearch] WHERE contains(Context, 'formsof (inflectional,"student''s") ')
i need to access Apostrophe (') in contains method
Changing the apostrophe into two apostrophes won't work (student''s Document). Been there. Done that. Can't do...
my accepting Result sholud be like
Student's Result.....................Something like this so my need is that 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 full-text search does not support the apostrophe in the search string?
Thanks In Advance:-)