Posted - 04/25/2013 : 10:24:12
| I have created substitution thesaurus entries for the following:
Pair: 1/2, half
Pair: 1/3, third
Pair: 1/4, quarter
Pair: 1/8, eighth
When I do a search with a search term such as, "1/2 inch pipe" I should get back rows that contain "1/2" as well as "half". I have two such rows. However, with default full-text search out of the box, it seems that "1/2" is not included in the results of the full-text indexing on the column in question.
I have not yet found a definitive answer as to what, where, how to configure a re-indexing of the full-text columns such that the full-text search criteria includes allowing 1/2, 1/3, etc. For that matter, I also need single numbers in the full-text search.
The use of like is not an option in my case. Surely other people are using data that contains fractions in the form of 1/2, etc., in full-text indexing.
I cannot use LIKE, nor can I change the data in the table(s). I have to find a way to configure the Full-text indexing and also insert pairs into the Thesaurus.
If someone could guide me to some documentation that covers the steps by which I can accomplish this task, I would greatly appreciate it.
Tomas / amateur radio NW7US