title: Converting text to int in sqlite when querying
body: <p>I want to convert both of the following columns to integer (they were placed as text in the SQlite db) as soon as I select them.</p>
  
  <pre><code> string sql4 = "select seq, maxLen from abc where maxLen &gt; 30";
  </code></pre>
  
  <p>I think it might be done like this..(using cast)</p>
  
  <pre><code> string sql4 = "select cast( seq as int, maxLen as int) from abc where maxLen &gt; 30";
  </code></pre>
  
  <p>Not sure if it's right as I seem to be getting a syntax error.</p>
  
  <p>How would I also convert the text to double</p>