title: SQL replace bullet points
body: <p>I'm using SQL Server 2014 and need to replace bullet points with a hyphen.</p>
  
  <p>I have data in a table (tblJobs) that looks like the below:</p>
  
  <pre><code>• Renew kitchen
  </code></pre>
  
  <p>If I paste this into Notepad ++ and change the encoding to ANSI I get the below: </p>
  
  <pre><code>â€¢ Renew kitchen
  </code></pre>
  
  <p>How do I replace the '•' to a '-'?</p>
  
  <p>This is my SQL:</p>
  
  <pre><code>Select RTRIM (REPLACE ([JobDesc],'â€¢', '-')) as Notes
  From tblJobs
  </code></pre>
  
  <p>However, the bullet points are still coming through.</p>
  
  <p>What am I missing?</p>