title: TEXTPTR in SQLITE
body: <p>I am searching for alternative to TEXTPTR in SQLite.</p>
  
  <p>I have a query in sql server 2005 express edition like:</p>
  
  <pre><code>SELECT @ptrval = TEXTPTR(STATUS_XML) 
    FROM JOB_STATUS_XML 
  WHERE job_guid = @JobGuid 
  
  UPDATETEXT JOB_STATUS_XML.STATUS_XML @ptrval @Pointer 5 @Result 
  </code></pre>
  
  <p>I have to convert it to a SQLite query.</p>