title: Searching using SQL Server Full Text Index support 'or not' operation
body: <p>Is there a way to support Boolean expression like</p>
  
  <pre><code>(x and y) or (not z)
  </code></pre>
  
  <p>in full text index search?</p>
  
  <p>I am using SQL Server 2016. </p>
  
  <p>I have read this article: <a href="https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql" rel="nofollow noreferrer">CONTAINS (Transact-SQL)</a></p>
  
  <p>I see that 'or not' is not supported. Any help?</p>