title: select data up to a space?
body: <p>I have an MSSQL database field that looks like the examples below:</p>
  
  <pre><code>u129  james
  u300  chris
  u300a jim
  u202  jane
  u5    brian
  u5z   brian2
  </code></pre>
  
  <p>Is there a way to select the first set of characters?  Basically select all the characters up until the first line space?</p>
  
  <p>I tried messing around with LEFT, RIGHT, LEN, but couldn't figure out a way to do it with variable string lengths like in my example.</p>
  
  <p>Thanks!</p>