title: count of of records containing string in SQL
body: <p>I have two strings in a column. I am looking to count.</p>
  
  <p><code>LIKE '%Alpha%' and LIKE '%Beta'%</code></p>
  
  <p>I am looking to just get a count of the number of times they appear in a table.  I thought this would be easy using <code>CASE</code>, but it doesn't seem to be fucntioning.  </p>