title: How to exclude special characters from select from where like - SQL Server
body: <p>I need to run this query, but it doesn't show anything:</p>
  
  <pre><code>select * 
  from table 
  where countries like '%Canada Italy France Belgica%'
  </code></pre>
  
  <p>But I have these values in my database:</p>
  
  <pre><code>Countries: "Canada, Italy, France, Bélgica"
  </code></pre>
  
  <p>If I do this query it works:</p>
  
  <pre><code>select * 
  from table 
  where countries like '%Canada, Italy, France, Bélgica%'
  </code></pre>