title: Is there an Oracle Trim equivalent that works on VARCHAR fields made up exclusively of whitespace?
body: <pre><code>SELECT 1 FROM dual where trim('X ') = 'X'
  </code></pre>
  
  <p>Gives 1.</p>
  
  <pre><code>SELECT 1 FROM dual where trim(' ') = ''
  </code></pre>
  
  <p>Gives no rows.</p>
  
  <p>Is there an easy way to select all rows where <code>field</code> is whitespace short of regex?</p>
  
  <p>Is there a way to "trick" TRIM into TRIMming <code>' '</code> and giving <code>''</code>?</p>