UPDATING a column to take first letter from another column
<p>I would like to UPDATE my table to replace / insert in the INITIALS column, the first letter in the first name column</p>

<p>Table name: Mano</p>

<pre><code>     Title  Firstname    Lastname    Telephone  Initial  Gender   More columns 
1    Mr     Adam             Smith         001    
2    Mrs    Angela           Evans         002       AE
3    Mr     Bill             Towny         003    
4    Miss   Dame             Beaut         004    
</code></pre>

<p>I am interested in transforming it as per below</p>

<pre><code>     Title  Firstname    Lastname    Telephone  Inital  Gender   More columns 
1    Mr     Adam             Smith         001      A
2    Mrs    Angela           Evans         002      A
3    Mr     Bill             Towny         003      B
4    Miss   Dame             Beaut         004      D
</code></pre>

<p>Many thanks </p>