All about  table called "People" whereas the Query refers to a table called "foo" was been told in other messages. Guys, try to formulate questions more accurately.

There is not comma between the last column declaration and constraint (primary key). The CREATE INDEX, where number of columns exceed maximum value, meets after. So, the correct answer is "syntax...

I'm agree, the question was done incorrectly.

To Sean O'Halpin.

As I understand, description field in second row:

"Grilled chicken (a souped-up BBQ recipe)"

matches to request (T), because there is not "soupe" as simple term.

Iouri.

I don't understand, why "Homemade Chicken Soup" must be returned on the query:

SELECT RecipeName FROM recipes WHERE CONTAINS(*, 'chicken AND NOT soup')

Can anybody clarify this?

Iouri.