title: Format phone number column to (555)555-5555
body: <p>My data looks like this: 347 210-4961</p>
  
  <p>I want to format it to this: (555)555-5555</p>
  
  <p>I've tried the following</p>
  
  <pre><code>REPLACE(REPLACE(REPLACE(REPLACE(HOME_PHONE,'(',''),' ',''),'-',''),')','')
  </code></pre>
  
  <p>But its come out like this: 7184455900</p>
  
  <p>My database comparability is at SQL Server 2005</p>