Full text query

Hi everybody, could somebody help me please? Is it possible to write fultext query with containstable, that will return all rows, in which the secified word doesn't appear? I have tried using something like this '"*" and not "word", but the wildcard doesn't return any row.

So anyone has an idea please?

Re: Full text query

I think you can't do like this, because wildcard is not supported in the query and "AND NOT" must be always combined with a search condition

( < contains_search_condition > ){ { AND | & } | { AND NOT | &! } | { OR | | } }

http://msdn.microsoft.com/en-us/library/ms189760.aspx

Re: Full text query

So there is no possibilty to search text which doesn't contains specified word?

Re: Full text query

Not with the full-text search, use a regular WHERE clause.