Hi John,
Sorry for delay in reply. I was on little holiday.
I am providing details below, you have asked for :
SELECT @@language
us_english
EXEC sp_help_fulltext_catalogs
5 FTOnDKPW C:\Program Files\Microsoft SQL Server\MSSQL\FTData 0 1
EXEC sp_help_fulltext_tables
dbo Book_Search PK_Book_Search 1 1 FTOnDKPW
EXEC sp_help_fulltext_columns
dbo 2009058193 Book_Search Title 3 NULL NULL 1033
dbo 2009058193 Book_Search Author 4 NULL NULL 1033
dbo 2009058193 Book_Search ISBN 5 NULL NULL 1033
dbo 2009058193 Book_Search Subject 6 NULL NULL 1033
In the table book_search, problem field in "ISBN". In my actual table,
ISBN are numeric and that is a child table of books. Now i have
prepared a search table for book search and have stored ISBN in a
varchar field separated by single space. Its sonmehow ignoring space
when a search for number. Its working fine if i place some special
character like #, @ at the begin and end of the ISBN number.
Regards
Amit
[quoted text, click to view] "John Kane" <jt-kane@comcast.net> wrote in message news:<ez3Y6aUAEHA.3804@TK2MSFTNGP09.phx.gbl>...
> Amit,
> Could you provide the below FT Catalog metadata and the exact values that
> are truly in Field1?
>
> SELECT @@language
> EXEC sp_help_fulltext_catalogs
> EXEC sp_help_fulltext_tables
> EXEC sp_help_fulltext_columns
>
> Full text search is somewhat problematic when with numbers as well as
> sensitive to any punctuation characters that are in contact or "touching"
> the search numbers &/or search words.
>
> Note, you can also post FTS related questions to the newsgroup:
> microsoft.public.sqlserver.fulltext
> Regards,
> John
>
>
>
> "Amit Srivastava" <sriamit76@yahoo.com> wrote in message
> news:47c83473.0403022348.3b52fba9@posting.google.com...
> > Hi,
> > I am facing a very strange problem with FTS. I have a full text
> > enabled table in which i have column with few integer values. If there
> > is more than one integer value in any row then it is separated by
> > space. e. g.
> >
> > Id Field1
> > -- ------
> > 1 10 11
> > 2 23 45
> >
> > Now when i make a search on this table with following query :
> > SELECT st.ID FROM SearchTable st(NOLOCK)
> > WHERE CONTAINS(Field1, '"1011"')
> >
> > It returns me ID : 1. I am not able to under what its doing to space.
> > This problem disappears as soon as i change "10 11" To "ab cd".
> >
> > Version details :
> > 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.0 (Build 2195: Service Pack 4)
> >
