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