FULLTEXT Index Thesaurus numeric values

Last Post 07 Jun 2010 05:35 PM by dcaparaso. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
New Member
New Member

07 Jun 2010 05: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

           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?


You are not authorized to post a reply.

Acceptable Use Policy