title: SQL table column forming from another columns
body: <p>I have a create table query, where I'm creating a table from another table's data. But I'm supposed to create new column from the same row's data.</p>
  <p>In example below, I need to get the first letter from ID from each row.</p>
  <p>For example what I have tried:</p>
  <pre><code>SELECT (SELECT SUBSTRING((SELECT ID
                            FROM tableWhereDataComes), 1, 1)) AS PERSONTYPE,
         ID , --This is a string like M101 or F101 etc.
         FIRSTNAME,
         LASTNAME
  FROM tableWhereDataComes
  </code></pre>
  <p>How do I get the required M or F to the first column PERSONTYPE?</p>