title: Trimming chr(49824) in the middle of a field in oracle
body: <p>Unable to trim the non breakable space in the middle of a filed in oracle
  '766195491                             572'</p>
  
  <p>Tried the below method it works only when non breakable space is present on the sides.</p>
  
  <pre><code>select length(trim(replace('766195491                             572',chr(49824),''))) from dual;
  </code></pre>