title: Replacing a string before the last "\" character in SQL query
body: <p>Query:</p>
  
  <pre><code>SELECT filePath FROM Table WHERE filePath IS NOT NULL
  </code></pre>
  
  <p>It'll return something like <code>\\server\folder1\folder2\filename.tif</code></p>
  
  <p>I need to query it to replace "<code>\\server\folder1\folder2\</code>" with a variable that's in the stored procedure (<code>@Path</code>) and end the format of the file like .jpg.</p>
  
  <p>So the result would be something like @Path + '.jpg'</p>
  
  <p>How would I go about doing this?</p>