title: SQL how to cut off string
body: <p>I have a column of strings with a city, state and number in each.</p>
  
  <pre><code>SPOKANE, WA           232/107
  LAS VEGAS, NV         232/117
  PORTLAND, OR          232/128
  </code></pre>
  
  <p>There are many more than just that, but I am wondering how either I could cut off the numbers in this column and just show the city and state or -even better- cut off the numbers and make city and state a separate column.</p>
  
  <p>The column is in the same format all the way down for all the different records.</p>
  
  <p>Thanks!</p>