title: How to replace part of string in a column, in oracle
body: <p>I am using oracle, toad.</p>
  
  <p>I want to replace , with backspace.</p>
  
  <p>Column consists of:  <code>bla bla foo ,CALL HELPDESK</code></p>
  
  <p>It has to replace:  <code>bla bla foo CALL HELPDESK</code></p>
  
  <p>Basically , should be removed</p>
  
  <p>I tried like this:</p>
  
  <pre><code>UPDATE Mytable t
     SET column = REPLACE(t.U_MSG, ''%, CALL HELPDESK'', '% CALL HELPDESK')
  </code></pre>