title: sql search on fields containing diacritics
body: <p>I'm working at a web site search which uses Sql server 2008 express edition.</p>
  
  <p>I have <strong>'Books'</strong> table which has a field named <strong>'Title</strong>' where there are titles containing romanian (latin) characters.</p>
  
  <p>Well, if the user inserts a word like: 'casa' in the search field and i have a title in db like: 'test <strong><em>casă</em></strong> test' i want to show that book but:</p>
  
  <pre><code>select * from books where title like '%casa%'
  </code></pre>
  
  <p>will not find it...</p>
  
  <p>Do you know any function which removes the diacritics when doing the select?</p>
  
  <p>I know that i can solve the problem with full text searching add-on of sql server but i want to do it in a simpler way.</p>