Re: Newbie

tou wrote:

> Hi,
>
> I need to make changes to telephone #'s in a field and I don't know what
> tool I need to use...
>
> In Access or MS SQL I select column, go to Edit and I choose Replace
> Option.. As easy as that...
>
> In fact I need to erease all spaces, dots, etc.
>
> TIA

UPDATE customers SET phone = REPLACE(phone, ' ', NULL);
UPDATE customers SET phone = REPLACE(phone, '.', NULL);
UPDATE customers SET phone = REPLACE(phone, '-', NULL);
UPDATE customers SET phone = REPLACE(phone, '/', NULL);

..should do it

Mfg, Robert Received on Sun Nov 10 2002 - 11:51:37 CET