Full Text Indexing - how to find "IT", but not "it"
-
I have an SQL 2000 DB with full-text indexing enabled. I'd like to find the word "IT" in a particular column, but not "it". Is there any way to do this? All other queries should still be case-insensitive.
-
Firstly, it/IT is an ignored (noise) word and unless you have removed it from the noise list you will not be able to search for 'IT' unless it is a part of a phrase, "now it is found" for example.
Secondly, FTS searching is case insensitive, so "it" and "IT" is the same. You will have to add an additional test to check for uppercase "IT" notwithstanding the above.
Far away is close at hand in the images of elsewhere.
Anon. -
Removing "it" from the noise words list is easy enough. The problem is case-insensitivity. If I have to process all the results of the query in code to filter out those that contain "it" and not "IT" that would almost defeat the point of FTS, because "it" is such a common word that about half of the records might contain it. There has to be a better way...
-
There has to be a better way... Not that I can think of
If it is only "IT" that are looking (probably not
) then you could add extra column to indicate presence of "IT" and set it at load/update timeFar away is close at hand in the images of elsewhere.
Anon.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply