title: Ignoring Apostrophes In Contains
body: <p>Simple question, perhaps a difficult answer.  We're using CONTAINS but when matching criteria containing apostrophes (because these are for French road names), then obviously they don't match.  So for example, searching for "Lislet" when the database contains "L'islet" yields nothing.</p>
  
  <p>I've looked into using dictionaries and thesauruses (SQL features) but unfortunately neither do the job.  Thesauruses looked very promising, but upon testing in our environment, it became apparent that they don't support apostrophes, which is a big shame 'cause that would've worked perfectly.</p>
  
  <p>The only other thing we're thinking of doing is creating a fully indexed view that strips out the apostrophes.</p>
  
  <p>Any other bright ideas?</p>