I believe we've got some users sharing passwords, so I want to catch them
>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
>> to 906-xxx-xxxx.
>> Can someone help me with the SQL to do this?
>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