title: how to delete everything after a blank space in access
body: <p>I have a table->column first-name with values:</p>
  
  <pre><code>Juan
  Manuel l.
  Richard Wit
  </code></pre>
  
  <p>I'm trying to do a query that return</p>
  
  <pre><code>Juan
  Manul
  Richard
  </code></pre>
  
  <p>I want to eliminate after a space.</p>