title: SQL - search by beginning of a word
body: <p>I want to write an SQL SERVER statement that searches for the beginning of a word in a string that starts with something.</p>
  
  <p>For example, if I search for 'em' on the Company record, I should get:</p>
  
  <p>Emily, Inc</p>
  
  <p>The Emmmy</p>
  
  <p>NOT</p>
  
  <p>Forget Them</p>
  
  <p>Lemming, LLC</p>
  
  <p>I can do this in PHP by extracting/slicing the string into an array and searching the beginning of each words.
  But how I would write this query in SQL server without resorting to Stored procedures/functions?</p>