<div>
update person set phone_number = replace(phone_number, '-', '')<br />
<br />
if you are running SQL 7.0 or 2000
</div>


update person set phone_number = replace(phone_number, '-', '')

if you are running SQL 7.0 or 2000

<div>
Trouta thanks you answered the question one last thing what if the phone number is formated like this (555)-555-5555 how can i remove the () and -'s &nbsp;thanks very much
</div>


Trouta thanks you answered the question one last thing what if the phone number is formated like this (555)-555-5555 how can i remove the () and -'s  thanks very much

<div>
<div class="content wysiwyg-content">
How can I write and update query to remove the dashes from my table. &nbsp;I have 2 phone number fields that look like this 555-555-5555 I want to remove the dashes.<br />
<br />
Thanks
</div>
</div>


How can I write and update query to remove the dashes from my table.  I have 2 phone number fields that look like this 555-555-5555 I want to remove the dashes.

Thanks

Remove - from phone number

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.