title: strip string after character
body: <p>Hello i have a column with a string value that looks like <code>test ( test):5</code> and i want to strip everything after <code>:</code> including this character.  </p>
  
  <p>I have the below sql and keep getting this error: </p>
  
  <blockquote>
    <p>[Teradata Database] [TeraJDBC 14.10.00.26] [Error 3706] [SQLState 42000] Syntax error: expected something between '(' and the string ':'. </p>
  </blockquote>
  
  <pre><code>select blah, LEFT(blah, CHARINDEX(':', blah) - 1) AS newblah from blah_table
  </code></pre>
  
  <p>can someone please help?</p>
  
  <p>thanks</p>