title: Replace spaces, tabs and carriage returns
body: <p>I am working with SQL developer with Oracle 11g. I have a query that looks something along the lines of this;</p>
  
  <pre><code>SELECT [column], [column], [column],...... rs.notes
  FROM [table], [table], [table]............ return_sku rs
  WHERE [conditions] AND [conditions] AND [conditions]
  </code></pre>
  
  <p>In the <code>return_sku</code> column there are tabs, spaces, and newlines (I believe this is a carriage return?) I need to make all of these spaces, carriage returns and tabs disappear when I run my query.</p>
  
  <p>I am fairly new to SQL, but the most popular search result I found is the REPLACE function. I have absolutely no idea how to use this, as I've tried this in many different ways with no result. I've tried the following;</p>
  
  <pre><code>SELECT [column], [column], [column],...... REPLACE(rs.notes, Char(10), '')
  FROM [table], [table], [table]............ return_sku rs
  WHERE [conditions] AND [conditions] AND [conditions]
  </code></pre>
  
  <p>This gives the error message:</p>
  
  <pre><code>ORA-00904: "RS"."NOTES": invalid identifier
  00904. 00000 -  "%s: invalid identifier"
  *Cause:    
  *Action:
  Error at Line: 3 Column: 531
  </code></pre>
  
  <p>How do I use this function correctly?</p>