title: SQLite INSERT command Syntax Help
body: <p>Greetings All,</p>
  
  <p>I have a SQLite database that I'm trying to add a new column to an existing table.  My current structure is:</p>
  
  <p>ID_NO, integer
  GUIDE, integer
  MATERIAL, text</p>
  
  <p>I would like to add a new column which is the first letter of MATERIAL
  KEY, text</p>
  
  <p>Here is what I tried, but I get an error that MATERIAL doesn't exist</p>
  
  <pre><code>INSERT INTO ERG_DATA (KEY) VALUES ( SUBSTR(MATERIAL,1,1))
  </code></pre>
  
  <p>Is INSERT the right command?  Any help would be appreciated.  Thanks in advanced!</p>