title: SQL Server - LIKE [XXXX]
body: <p>I'm trying to return only values which contain the text [XXXX] in a specific field.
  My query is returning values which have 4 digit numbers, as I assume SQL server is treating [XXXX] as any number with 4 digits.</p>
  
  <p>I have a test query below with values list to demonstrate the problem.</p>
  
  <pre><code>select X.VadDesc 
  From (VALUES
  ('Product AAAA Description'), 
  ('Product BBBB Description'), 
  ('Product [XXXX] Description'), 
  ('Product2 [XXXX] Description'), 
  ('Product 2 [AAAA] Description'), 
  ('Product X 1234 Description'),
  ('Product X 1235 Description'),
  ('Product X 1236 Description'),
  ('Product X 1237 Description')
  ) as X (VadDesc)
  Where X.VadDesc like '%[XXXX]%'
  </code></pre>
  
  <p>My query should only return:</p>
  
  <pre><code>Product [XXXX] Description
  Product2 [XXXX] Description
  </code></pre>
  
  <p>But it returns:</p>
  
  <pre><code>Product [XXXX] Description
  Product2 [XXXX] Description
  Product X 1234 Description
  Product X 1235 Description
  Product X 1236 Description
  Product X 1237 Description
  </code></pre>
  
  <p>How can I do this?
  I don't just want to look for XXXX as this this may be in rows I don't want to return.</p>