title: SQL - Remove Parenthesis from Phone Number
body: <p>I'm trying to remove parenthesis from the area code of a number. I'm able to do so but when I try to concatenate the two Replace functions, the numbers repeat with only one parenthesis removed.</p>
  
  <p>This is what I tried so far:</p>
  
  <pre><code>SELECT HomePhone, REPLACE(HomePhone, '(', '') + 
  REPLACE(HomePhone, ')', '') AS Expr1
  FROM dbo.Employees
  </code></pre>
  
  <p><a href="http://i.imgur.com/4iJoFzE.png" rel="nofollow">http://i.imgur.com/4iJoFzE.png</a></p>