title: Filter a field containing a value
body: <p>I'm starting to learn SQL. Im using SQL Server Management Studio to write my queries in. I unserstand that I can filter a field contaning a given value (for example : product A, product A (cost), product B, product B (cost)) so in this instance I can filter out values containing "(cost)". I've arrived at the following query but its failing. Can you tell me why.</p>
  
  <pre><code>SELECT     billing_code, billing_code_desc
  FROM         dbo.jm_billing_code
  WHERE     (NOT (billing_code_desc = N'CONTAIN [(cost)]'))
  ORDER BY billing_code
  </code></pre>