title: How to rewrite phone numbers in T-SQL?
body: <p>I have a beginners question in T-SQL.</p>
  
  <p>We imported Excel Sheets into a SQL Server 2008. Too bad these Excel files were not formatted the way they should be. We want a phone number to look like this: '012345678', no leading and trailing whitespace and no whitespace within. Even worse sometimes the number is encoded with a prefix '0123-2349823' or '0123/2349823'.</p>
  
  <p>Normally I would export the Excel file to a <a href="http://en.wikipedia.org/wiki/Comma-separated_values" rel="nofollow noreferrer">CSV</a> file, then launch some magic Perl script to do the cleaning and then reimport the Excel file.</p>
  
  <p>Still it would be interesting to know how to do stuff like this with T-SQL.</p>
  
  <p>Any ideas?</p>