title: How to remove specific character from string in spark-sql
body: <p>I want to convert '123,456' to 123456 (string to int) by spark-sql.</p>
  
  <p>I tried like this.</p>
  
  <pre><code>REPLACE('123,456', ',', '')
  </code></pre>
  
  <p>But it didn't work, because spark-sql don't permit REPLACE()</p>