title: SQL string manipulation [Get all text left of '(']
body: <p>I have some data which looks like so:</p>
  
  <pre><code>SourceOfBooking
  ----------------
  Company1 (Foo)
  Company2 (Bar)
  Company3 (Foo1)
  Company4 (Foo2)
  </code></pre>
  
  <p>I am looking to transform this, so my data only displays:</p>
  
  <pre><code>SourceOfBooking
  ----------------
  Company1
  Company2
  Company3
  Company4
  </code></pre>
  
  <p>I have tried:</p>
  
  <pre><code>LEFT(SourceOfBooking, CHARINDEX(';', SourceOfBooking) )
  </code></pre>
  
  <p>with no luck.</p>
  
  <p>I'm sure I'm missing something incredibly simple... Anyone care to enlighten?</p>
  
  <p>KR, James.</p>