Teradata LEFT() function issue
<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>