Hi all,

I have set up two tables like this:

TABLE1
field1 varchar(8000)

TABLE2
field1 text

I am implementing a full-text search and was wondering what your recommendations are to get the best results. Since the data I am storing are news articles that could be 20k in length, TABLE1 would have multiple rows indexed by a new_id integer field, whereas TABLE2 would have all data stored in the text field.

On both tables I have tested CONTAINS, FREETEXT and CONTAINSTABLE. While the first two return fairly similar results, the results from CONTAINSTABLE are completely different.

My phrase is '"Maple" AND "Leafs" AND "First" AND "Period"'. Is thee beast use of the search syntax if the user entered "Maple Leafs First Period"?

TIA,
Michael