title: Update substring of a column
body: <p>I have a table within a SQL Server 2008 database called <code>Meter</code>. This table has a column called <code>Name</code>. </p>
  
  <p>Each entry within the column <code>Name</code> has a prefix of the following <code>ZAA\</code>. I'd like to change this prefix to <code>ZAA_</code> without affecting the rest of the text within the column.</p>