title: T-SQL: How to add string at a certain index of another string?
body: <p>I've a table called <code>EmailTemplates</code>, which has the column <code>MessageText</code>. For each row, I'd like to add a <code>Please review details</code> before <code>Thank you</code>.  For some rows, there might text after <code>thank you</code>.</p>
  
  <p><strong>BEFORE</strong></p>
  
  <pre><code>All the correspondence will be sent to your address.
  
  Thank you!
  </code></pre>
  
  <p><strong>AFTER</strong></p>
  
  <pre><code>All the correspondence will be sent to your address.
  
  Please review details
  
  Thank you!
  </code></pre>
  
  <p>I don't know whether <code>REPLACE</code> is the right function for that.</p>