title: Teradata LEFT() function issue
body: <p>I run the following query against Teradata using SAS, and it works fine </p>
  
  <pre><code>SELECT LEFT(first_name,7) 
  FROM testTab 
  </code></pre>
  
  <p>However, when I run the same query in <code>Sql Assistant</code> it throws an error : <code>Expected something between keyword SELECT and keyword LEFT</code>. </p>
  
  <p>On my other computer, the above code runs on <code>Sql Assistant</code>. </p>
  
  <p>So, my question is, why does the <code>LEFT</code> function work sometimes, and sometimes it doesn't ? </p>
  
  <p><strong>There are a lot of workarounds, but I want to know what the hell is going on with this <code>LEFT</code> function ?</strong> </p>