title: Better SQL Replace
body: <p>I wanted to know if there is a better way of writing this Update.</p>
  
  <pre><code>update Alumni_Export_New
  set phone = replace(replace(replace(replace(phone,'-',''),' ',''),')',''),'(','')
  from tbl
  </code></pre>
  
  <p>I have a stored procedure in MSSQL 2005 to clean the phone field in a table and thought there should be a better way of doing this then what I have. </p>