SQL Server Full Text Search NOT Operator

Question

I want to searh my full text index with NOT operator.

SELECT * FROM CONTAINSTABLE(MY_TABLE, *, 'NOT name'),

The following exception:

Msg 7630, Level 15, State 3, Line 1
Syntax error near 'name' in the full-text search condition 'NOT name'.

What is the wrong? How can search my full text index with just NOT operator?

Thanks

Answer 1

instead of not, you can use not contains :

SELECT * FROM MY_TABLE
where not contains( *, 'name')

For reference :

http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/