CONTAINS function ain't doin' nuthin'

[kempis555]

This is bugging me to no end. Even using the example in the SQL help books, I can't get the CONTAINS function to return anything. Here's a sample:

SELECT Description
FROM Categories
WHERE CONTAINS(Description, '"bean curd"')

that returns bupkis. Zilch. Nada.

However, the following code:
SELECT Description
FROM Categories
WHERE Description like '%bean curd%'

returns "Dried fruit and bean curd" as it should. I can't think of what could be causing this, full-text indexing is enabled for that column (it gave an error before I enabled it) ???

-k

 

[kempis555]

Nevermind I found the problem.

I ran the incremental indexing thingie and now it works.

It seems that enabling full text indexing didn't actually make a full index... sure seemed like it was doing SOMETHING for how long it took.

Ugh, how nasty. I can imagine this not working if the data was new to the table before the index was refreshed, but not this.

-k