title: Insert character into SQL string
body: <p>I have an nvarchar column I need to insert a hyphen at fixed points within the string. The hyphen need to go between the rightmost character and the next, and again in the 3rd position from the right, such as:
  column value is </p>
  
  <pre><code>0000050704 
  </code></pre>
  
  <p>and I need it to be </p>
  
  <pre><code>0000050-70-4
  </code></pre>
  
  <p>or value is </p>
  
  <pre><code>0555256321 
  </code></pre>
  
  <p>and it should be </p>
  
  <pre><code>0555256-32-1
  </code></pre>
  
  <p>Can't see how this is done. Can anyone give me a little help?</p>