I know the period is a word breaker however I want to be able to search the fulltext catalog for a field containing the phrase "ASP.Net" or similar.
Currently my search returns 'ASP' and 'Net' without them occurring consecutively in the text. I want to know if there is a way to stop the period (.) acting as a word breaker for specific searches?
My research so far just suggests I use a LIKE statement however this is not feasible as there are millions of rows with large text fields to search as quickly as possible.