Marcus,
Could you post the full output of -- SELECT @@version -- as this is
especially important information for this type of SQL FTS issue?
While your questions are generic and understandable, the answers are highly
dependent upon the OS Platform (Windows 2000 Server vs. Windows Server 2003
or Windows XP) regardless of your SQL Server version (although, this too
would be helpful info).
Could you also post the SQL FTS query (contains or freetext) as well as true
sample of the data, including all punctuation characters relative to the
numbers, letters, and words you are searching for? Finally, the contents of
the language-specific noise word files, (noise.enu = US English) under
\FTDATA\SQLServer\Config\ as both single digit numbers and single letters
are by default included in the noise word files and this numbers and letters
are not FT Indexed and can affect your expected results.
Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/ [quoted text, click to view] "Marcus Baffa" <Marcus Baffa@discussions.microsoft.com> wrote in message
news:DCF8226A-D113-4600-A373-E104FE615746@microsoft.com...
> I have create a Catalog and I am trying to find a record in the database
that
> satisfies the term: 102/3 or 102-3
>
> These two terms works exactly the same way. The SQL searches for records
> that have 102 or 3 in any position in the record, including in the middle
of
> a word.
>
> I have concluded that these charecters represent separators and in fact I
am
> making a query to find records that have the two simple terms 102 or 3.
>
> - Is it right ???? these charecters (/, -) have really the same effect.
Are
> both separators ????
> - In that case where can I find a list of the other special use
characters,
> if they exist, and how they can be used ????
> - How can I query the database to find the term "102-3" as it is written.
> (By the way I have already tried to uses the double quotes and got the
same
> answer).
>
> Thanks in Advance
