title: How to search for specific column name within one table
body: <p>I have searched this question on stackoverflow but most of the questions are a little deeper than what I want.  Many questions are relating to finding the table that has the specific column name.  </p>
  
  <p>I am connected to the database through <code>SSMS</code>.  I have found the table that I want to search through by <code>SELECT * FROM Item</code>.  In the <code>Item</code> table I want to search all of the field names (or name of the column) and <code>select</code> the ones that contain a specific string <code>'Size'</code>.  I thought something like this would work </p>
  
  <pre><code>Select * FROM Item WHERE column_name LIKE '%SIZE%'
  </code></pre>
  
  <p>It doesn't work though. How do I specify it to search through all of the column names to find the names that contain 'Size'?</p>
  
  <p>Thanks.</p>