title: T-SQL - GROUP BY with LIKE - is this possible?
body: <p>Is there a way to include a LIKE expression in a GROUP BY query?  For example:  </p>
  
  <pre><code>SELECT Count(*) 
  FROM tblWhatever
  GROUP BY column_x [LIKE %Fall-2009%]
  </code></pre>
  
  <p>column_x:</p>
  
  <pre><code>--------
  BIOL-Fall_2009
  HIST Fall_2009
  BIOL Spring_2009
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>------
  Fall_2009   2
  Spring_2009 1
  </code></pre>