title: remove dashes from a column in a select statment without altering table data
body: <p>I have a query that grabs a list of 'job numbers' from a table. However, the job number displays numbers with a dash in the middle.<code>(e.g. 645-123)</code></p>
  
  <p>How do I select this field and only retrieve the number up to the dash (<code>e.g.'645'</code>) and not the <code>'-123'</code>?</p>
  
  <p>I do not want the data in the table to be 'replaced' or edited; I just need to select the data but without the dash and remaining digits after the dash.</p>
  
  <p>Thanks for any help</p>