title: SQL Server 2012 - Using REPLACE + Regex in a SELECT column to format the value
body: <p>I have a table containing values like this:</p>
  
  <pre><code>+----+------------------------------------------------+
  | ID |                   AssignedTo                   |
  +----+------------------------------------------------+
  |  1 | 92;#Alex Smith;#114;#Joe Day;#184;#Johnny Bone |
  +----+------------------------------------------------+
  </code></pre>
  
  <p>And I would like to remove the "[number];#" and replace it for a single dash "-" for every occurrence</p>
  
  <pre><code>+----+------------------------------------+
  | ID |             AssignedTo             |
  +----+------------------------------------+
  |  1 | Alex Smith - Joe Day - Johnny Bone |
  +----+------------------------------------+
  </code></pre>
  
  <p>Is this possible with default SQL Server 2012 functions?</p>
  
  <p>Thanks!</p>