title: sqlite replace() function to perform a string replace
body: <p>I have a column in a sqlite database that I need to modify. </p>
  
  <p>The column is an array of values that looks like this:</p>
  
  <pre><code>0.021460.04419,0.04551,0.02734,0.011,0.005
  </code></pre>
  
  <p>The array is missing a comma between the first and second value, so the array should look like this:</p>
  
  <pre><code>0.02146,0.04419,0.04551,0.02734,0.011,0.005
  </code></pre>
  
  <p>The data values will never be greater then 0.9, so I am trying to build an update query that will use the replace() function to perform a string replace, identifying the second "0." and replacing it with ",0.", but I have no idea how to do this.</p>