title: Replace first word in a string within query
body: <p>running SQL sever 2016</p>
  <p>say i have values like</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Type</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Coat 2</td>
  </tr>
  <tr>
  <td>Furry Coat 1</td>
  </tr>
  <tr>
  <td>Coat 2</td>
  </tr>
  <tr>
  <td>Furry Coat 3</td>
  </tr>
  <tr>
  <td>Coat 5</td>
  </tr>
  <tr>
  <td>Furry Coat 1</td>
  </tr>
  <tr>
  <td>Coat 3</td>
  </tr>
  <tr>
  <td>Furry Coat 3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>i want to replace all the strings that say &quot;Coat&quot; to &quot;Skinny Coat&quot; within my query but i dont want to include the &quot;Furry Coat&quot; values.
  how do i do this?
  i tried using the</p>
  <pre><code>replace(Type, 'Coat', 'Skinny Coat') as Type
  </code></pre>
  <p>but it changes all strings</p>
  <p>thanks</p>