How to substring characters in sql : <p>Need your help guys! I don't know how to use substring yet.
For example I have data like this </p>

<pre><code>+-----------+
+   Model   +  
+-----------+              +-----------+
|Pal5c32gld |   OUTPUT&gt;&gt;&gt;  |  Pal5c    |
|Pal5s64slv |              |  Pal5s    |
|Pal5sp32gry|              |  Pal5sp   |
|Pal6e16slv |              |  Pal6e    |
|PALs32ilver|              |  Pals     |
|PalSE64gold|              |  PalSE    |
 ___________               _____________
</code></pre>

<p>TIA!</p>
