title: Index of substring in SQLite3?
body: <p>What's the most straightforward way of finidng the index of a substring in a varchar column?  <code>charindex</code> doesn't exist in the stock version of SQLite3 -- which is still a little surprising to me.</p>
  
  <p>Specifically, I have a column with values like <code>010000</code>, <code>011000</code>, <code>010110</code>, etc.  I want to find the index of the first occurence of <code>11</code>.  For the examples I gave, I would expect something like <code>NULL</code> (or <code>-1</code>), <code>1</code>, and <code>3</code>.</p>
  
  <p>I have a hacked together idea that uses <code>length</code> and <code>ltrim</code>, but it seems like a lot of work for something I need to do several times.</p>