FULLTEXT Index Thesaurus numeric values

Last Post 07 Jun 2010 06:35 PM by dcaparaso. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
dcaparaso
New Member
New Member

--
07 Jun 2010 06:35 PM

I have a full text index, consisting of products and their descriptions.  Most of the descriptions are sized based, ie. 2" x 4" x 6" Box or 2.50" x 6" Pole, etc...  I'm having issues getting a fulltext query to work properly, users may enter 2" or 2 in or 2in. or 2 inch, etc. all the different ways to possibly say 2 inch.  I thought I'd be able to setup expansion entries in the thesaurus file, but it doesn't seem to be working properly, it looks like SQL is adding nn as a prefix to the number, then throwing a duplicate thesaurus phrase error, I don't think I'm handling the " properly, etc. 

I've tried
 
           in
        inch
        in.
        inches
      


or
 
           2 in
        2 inch
        2 in.
        2 inches
      


and quite a few other variations, I'm thinking in maybe causing some grief since its a system stopword, but I thought it being a thesaurus entry overrides the noise list.

Any ideas?

Thanks,
David



Acceptable Use Policy
---