Fulltext Search including brackets and full stop

Category: sql server search


farahijahromi on Tue, 25 Sep 2018 03:49:59

I am trying to implement a solution that if for instance the database holds the following text

"Carbon Dioxide 0.2M (2mml)"

a user should be able to search using any of the following keywords:

1- "carbon" or "dioxide" or "0.2M" or "(2mml)" or "2mml"

2-  "carbon dioxide", "dioxide carbon","carbon 0.2m", "dioxide (2mml)", "Carbon Dioxide 2mml", 0.2M

I have tried using CONTAINS but it won't come back with any result if the search has brackets or full stop.

Any help is appreciated.


Olaf Helper on Tue, 25 Sep 2018 05:48:16


How exactly does your T-SQL statement look like? Because the most of you search Terms should work.

select *
from sys.dm_fts_parser('"Carbon Dioxide 0.2M (2mml)"', 1033, 0, 0)