title: SQL query stemmer removing quotes and ending character
body: <p>Currently If a user inputs company name as "Bob's Place", my stemmer will remove 's and return "Bob Place".  However I'm having issue with sql data side</p>
  
  <p>What I would like to do is bring back companys that match the stemmed word, however in the database side has the company name "Bob's Place".</p>
  
  <p>Any way i can remove <code>'s</code> and compare "bob place"?</p>
  
  <pre><code>select * 
  from ops..companyinfo with(nolock) 
  where SUBSTRING(name, 0, charindex(CHAR(39),name))  like '%bob place%'
  </code></pre>
  
  <p>Currently its comparing 'bob' = 'bob place'</p>
  
  <p>Currently need if a company in the database name called Mike's Place need to be Mike place</p>