title: How to find power of a number in SQLite
body: <p>I want to update the Interest field in my database. My SQL query is like as per below </p>
  
  <blockquote>
    <p>Update Table_Name set Interest  = Principal * Power(( 1 + (rate /
    100),year)</p>
  </blockquote>
  
  <p>This query works fine in MySQL but don't work with SQLite.</p>
  
  <p>The error says that <strong>No Power funcation found</strong> </p>
  
  <p>Does anyone know how to resolve this problem as I have to do this using query to update more than 3000 records at a time. </p>