Re: [Emerald] Change Fields

Dale E. Reed Jr. ( (no email) )
Mon, 29 Mar 1999 23:28:20 -0800

Wayne Griswold wrote:
>
> I would like to make a global correction to my data base as follows:
> I'd like to replace everyone who's phone number was entered as 906/xxx-xxxx
> to 906-xxx-xxxx.
> Can someone help me with the SQL to do this?

Update MasterAccounts
Set PhoneWork = '906-' + substring(PhoneWork,5)
Where PhoneWork like '906/%'

Change PhoneWork to PhoneHome and PhoneFax to get them all. There is
also a PhoneWork and PhoneHome in the SubAccounts table as well.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html