Description: We are using a DTS to build a table just for FT indexing.
Basically we gather all of the words from the fields we'd like to search,
and put them into a single table (moosejaw_tblFullText). Then we're using
FormsOf (Inflecitonal...) to get results as the SQL below shows.

For one of our customers, we need to be able to differentiate between words
like "person", "2-person", and "4-person". Right now the SQL below returns
ALL results for "person". From what I've read, I believe it is considering
the dash "-" to be a word, and since "2" is a noise word, it effectively
only searches for "person". I read that this was fixed in Windows Server
2003, in the langwrbk.dll, but it does not appear so.

Does anyone have any suggestions or ideas?

SQL:
Select uvw.pf_id, ft.* From uvw_cat_prod_backorder uvw, moosejaw_tblFullText
ft Where uvw.pf_id=ft.pf_id AND Contains(ft.Description,' FORMSOF
(INFLECTIONAL, "2-person") ')

@@version:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)

Thanks,
Brad

Hello Brad,

This behavior is as designed. Please refer to the following article:

200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS
Queries
http://support.microsoft.com/?id=200043

A custom word breaker that does not break on hyphens is the only solution
from a
purely Indexing Service standpoint. The following links are for your
reference:

Word Breaker and Stemmer Sample
<<http://msdn.microsoft.com/library/en...nario_3e91.asp
?frame=true>>

Constructing Language Resource Components
<<http://msdn.microsoft.com/library/en...nario_9i0j.asp
?frame=true>>

Implementing a Word Breaker
<<http://msdn.microsoft.com/library/en...nario_54bp.asp
?frame=true>>

Property Names
<<http://msdn.microsoft.com/library/en..._4er7.asp?fram
e=true>>


Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------