title: SQL replace č, ć, ž with letter c, z
body: <p>I've got a table with column Last Name. I want to change a part of strings in the column.</p>
  
  <pre><code>select REPLACE([Last Name],'Ć','s')  FROM myTable1
  </code></pre>
  
  <p>don't work.</p>
  
  <p>If I put this  </p>
  
  <pre><code>select REPLACE([Last Name],'o','s')  FROM myTable1
  </code></pre>
  
  <p>it is work.</p>
  
  <p>How to change č,ć,ž with another lettter.</p>