Showing posts with label formof. Show all posts
Showing posts with label formof. Show all posts

Wednesday, March 7, 2012

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.