I have implemented Full Text Search to search the PDF files (stored as varbinary(MAX)).
It is worknig great.
But today I saw the user-activity table and I found someone was trying to search for
a phrase '44 f(2) E' but the search returned all the matchnig files having
either 44
or 44f
or 44 f
or 44 f(
even files having 44A, 44B, 44 A C .....
etc.
How can I tell the FTS that the phrase to be searched is actually the whole word
'44 f(2) E'
i.e 44 AND space AND f AND (2) AND space AND E
(I mean how to implement a scenario like an advance search)
Thanks in advance!