Try
SELECT *
FROM table2
WHERE CONTAINS(field1, ' Maple AND Leafs AND First AND Period ')
>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"?
>
--sb--