title: How to find names with special characters like 'José' on MS SQL-Server
body: <p>If i search for 'Jose' the result is 0. If i search for 'Josè' either and 'Jôse' gives also no result.</p>
  
  <pre><code>select name from TblName where name = 'Jose' or name = 'Josè' or name = 'Jôse'
  </code></pre>
  
  <p>I know the replacement with ? : <code>where name like 'Jos?' or name like 'J?se'</code> But this is very unhandy and who knows if there is not a special form of 's'? </p>
  
  <p>I want to search for 'Jose' and get all the variants of it with all the possible special characters on all single characters; how do that?</p>