Re: [Emerald] Change Fields

Don Barron ( (no email) )
Tue, 30 Mar 1999 17:12:36 +0930

While talking about global changes, how do I set up CallerID for all the
users
that are already in Emerald.

I believe we've got some users sharing passwords, so I want to catch them
out.

Thanks.....

>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
>

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