title: How to replace instr() function in SQLite?
body: <p>Given that <strong><code>instr()</code></strong> function isn't supported in SQLite KitKat Android how can I obtain following expression in a SQL statement?</p>
  
  <pre><code>substr(mystring, instr(mystring, '_')+1)
  </code></pre>
  
  <p>My target is to get first part of a string until <strong>'_'</strong> where its position is variable. I use this expression in a <code>JOIN</code> clause and I need it directly in <strong><code>SQL</code></strong>.</p>
  
  <p>Thanks in advance.
  Danilo</p>