title: SQL Server 2008 - Add to string in particular position within name column
body: <p>I have been asked to do a job which is beyond my SQL skills a little and having done some research online, cannot quite find the write solution to be done in SQL Server 2008 and not MySQL.</p>
  
  <p>I have a table where I need to update specific names by adding an additional string after a certain point whilst keeping the rest of the string to the right intact.</p>
  
  <pre><code>e.g.
  
  Current Name = 'Name - Location - 0005'
  New Name = 'Name (West) - Location - 0005'
  </code></pre>
  
  <p>As you can see I need to add the text (West), I have a table which lists all the codes (e.g. 0005) and I need to link that into my where clause to only update the relevant names.</p>
  
  <p>So the questions are:</p>
  
  <p>1 - How can I update the Name by adding additional text at a set location (5th character), whilst maintaining whatever text is to the right of the names</p>
  
  <p>2 - Is there a way that I can do a sort of like in to check the code, I tried using Contains however the table is not full-text indexed. This is not a massive issue as I can manually create update statement using just like for each row within the table, would just be a nice to know to add to my knowledge base.</p>