Hello,

At last I've found this group as I've been struggling with this by myself
for some time now. I'm fairly new to this so I'm hopeing that this should be
an easy thing for you guys to help with, so here goes...

I have a SQL 2000 Server running the FTS on a Windows 2000 Server. I have
created a Database of name Documents and a table within it named
tbl_Documents which contains six fields. These fields are and ID (int and
key), Document (image), DocType (char), FileName (char), LoadDate (datetime)
and Spare (char). I have created a Full-Text Index for this table indexing
the Document and Spare columns and using the Englidh (United Kingdom) word
breaker with the DocType field as the Document Type column. At the moment
there are no schedules set up to repopulate it. I then start a full
population to, well populate it!

The table has four records (it's still only under test!) with four separate
documents each containing only one line of text. The Spare column contains
the words Test, Testing, <Null> and Tested. The DocType fields all contain
the string 'doc'.

Looking at the properties for the catalog that has been created I have an
Item Count of 5 and a Unique key count of 12. This implies to me that it has
populated the catalog correctly as there are probably only about 12
non-noise words in there. Although if I remove the Spare column from the
index and rebuild it I get a Unique key caont of 8 (why not 9 as one of the
spare fiels is <Null>?).

So far all well and good. I also have an ASP.NET form hosted on a separate
IIS5 box that hopefully will permit the user to enter a search word into a
field and return the results in a datagrid which is set to create columns
automatically at runtime. The query used to get the data is:

SELECT * FROM tbl_Documents WHERE CONTAINS (Document,'" & tbSearch.Text &
"')

If I run this query with the word 'Test' as tbSearch I would expect to get
two records returned as two documents contain the word test. However I get
only the column headings and no data. If I modify the query to search the
Spare column rather than the Document column (whilst the Spare column is
included in the index) I do get the three variants of the word Test as
expected.

From what I have explained above (although quite long winded), is there
anything obvious that i'm doing wrong? If you think you can help and need
more info then please let me know.

Thanks,

<M>ike