Quick Query

Our dev database was not built correctly for phone #'s so all of the
sample data or test data (not sure if it is legit) has them in the form
of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from
those values and turn it into XXXYYYZZZZ?
Thanks.Try:
update MyTable
set
Phone = replace (Phone, '-', '')
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<josh.tucholski@.gmail.com> wrote in message
news:1156253610.284442.275620@.i3g2000cwc.googlegroups.com...
Our dev database was not built correctly for phone #'s so all of the
sample data or test data (not sure if it is legit) has them in the form
of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from
those values and turn it into XXXYYYZZZZ?
Thanks.|||update YourTable
set PhoneNumber = replace(PhoneNumber, '-', '')
-Sue
On 22 Aug 2006 06:33:30 -0700, josh.tucholski@.gmail.com
wrote:

>Our dev database was not built correctly for phone #'s so all of the
>sample data or test data (not sure if it is legit) has them in the form
>of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from
>those values and turn it into XXXYYYZZZZ?
>Thanks.