title: Removing spaces from a string, SQL
body: <p>I'm trying to write a SQL query that will remove all spaces so that if a string only has spaces the final string is just ''.</p>
  
  <p>I've tried this code but apparently it isn't working for more than one space:</p>
  
  <pre><code>regexp_replace(:P14_search_text, '( ){1,}', '')
  </code></pre>
  
  <p>Being :<code>P14_search_text</code> the string I want to modify.</p>
  
  <p>Any help?</p>